/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package GUI;

import Bussiness.DepartmentDAO;
import Bussiness.EmployeeDAO;
import Bussiness.LocationDAO;
import Bussiness.ProjectDAO;
import Bussiness.TransferDAO;
import Connection.Admin;
import Connection.CheckInfo;
import Connection.Project;
import Connection.DBUtil;
import Connection.Employee;
import Connection.Transfer;
import java.awt.event.KeyEvent;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Time;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
//import java.util.Date;
import java.sql.Date;
import java.util.Vector;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JOptionPane;


/**
 *
 * @author SONY
 */
public class EmployeeMain extends javax.swing.JFrame {

    private String oldPass;
    private String employeeID = null;
    private int index = 0;
    private String abc = null;
    //Connection conn;
    DBUtil objDBUtil;
    Employee objEmployee;
    Transfer objTransfer;
    Connection conn;
    private static CallableStatement cs = null;
    ResultSet rsProject;
    ResultSet rsLocation;
    ResultSet rsDepartment;
    ResultSet rsEmployee;
    ResultSet rsTransfer;
    /**
     * Creates new form AdminMain
     */
    public EmployeeMain() throws Exception{
        initComponents();
        loadSearchDerpartment();
        loadSearchLocation();
        loadSearchProject();
        loadSearchEmployee();
        loadStatistical();
        loadDepartmentSelect();
        loadLocationSelect();
        loadProjectSelect();
        loadEmployeeNameSelect();
        loadMenu();
        //searchTransferByEmployeeID();
        
    }
    

    /**
     * This method is called from within the constructor to initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is always
     * regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        buttonGroup1 = new javax.swing.ButtonGroup();
        jToolBar1 = new javax.swing.JToolBar();
        jPanel1 = new javax.swing.JPanel();
        jPanel2 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        jTabbedPane2 = new javax.swing.JTabbedPane();
        jPanelHome = new javax.swing.JPanel();
        jPanel4 = new javax.swing.JPanel();
        lblEmail = new javax.swing.JLabel();
        lblFullName = new javax.swing.JLabel();
        lblEmailText = new javax.swing.JLabel();
        lblFullNameText = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        lbkDateText = new javax.swing.JLabel();
        jPanel3 = new javax.swing.JPanel();
        jLabel21 = new javax.swing.JLabel();
        jLabel22 = new javax.swing.JLabel();
        lblTotalApprove = new javax.swing.JLabel();
        lblTotalNotApprove = new javax.swing.JLabel();
        btnViewDetaiTotalTransferApprovel = new javax.swing.JButton();
        btnViewDetailTotalTransferNotApprove = new javax.swing.JButton();
        btnViewDetailTotalTransfer = new javax.swing.JButton();
        jLabel31 = new javax.swing.JLabel();
        lblTotalTransfer = new javax.swing.JLabel();
        btnViewDetailTotalEmployee = new javax.swing.JButton();
        lblTotalEmployee = new javax.swing.JLabel();
        jLabel23 = new javax.swing.JLabel();
        btnViewDetailTotalProject = new javax.swing.JButton();
        lblTotalProject = new javax.swing.JLabel();
        jLabel26 = new javax.swing.JLabel();
        btnViewDetailTotalLocation = new javax.swing.JButton();
        lblTotalLocation = new javax.swing.JLabel();
        jLabel32 = new javax.swing.JLabel();
        btnViewDetailTotalDepartment = new javax.swing.JButton();
        lblTotalDepartment = new javax.swing.JLabel();
        jLabel34 = new javax.swing.JLabel();
        jPanelProject = new javax.swing.JPanel();
        jPanel5 = new javax.swing.JPanel();
        jLabel3 = new javax.swing.JLabel();
        txtSearchProjectID = new javax.swing.JTextField();
        btnSearchProject = new javax.swing.JButton();
        jLabel6 = new javax.swing.JLabel();
        cbSearchProject = new javax.swing.JComboBox();
        jPanel15 = new javax.swing.JPanel();
        jLabel9 = new javax.swing.JLabel();
        lblProjectStt = new javax.swing.JLabel();
        lblProjectID = new javax.swing.JLabel();
        jLabel12 = new javax.swing.JLabel();
        txtProjectName = new javax.swing.JTextField();
        lblProjectName = new javax.swing.JLabel();
        txtProjectAllowance = new javax.swing.JTextField();
        jLabel68 = new javax.swing.JLabel();
        jLabel10 = new javax.swing.JLabel();
        jPanelLocation = new javax.swing.JPanel();
        jPanel6 = new javax.swing.JPanel();
        jLabel4 = new javax.swing.JLabel();
        txtSearchLocation = new javax.swing.JTextField();
        btnSearchLocation = new javax.swing.JButton();
        jLabel8 = new javax.swing.JLabel();
        cbSearchLocation = new javax.swing.JComboBox();
        jPanel8 = new javax.swing.JPanel();
        jLabel13 = new javax.swing.JLabel();
        jLabel14 = new javax.swing.JLabel();
        jLabel15 = new javax.swing.JLabel();
        txtLocationName = new javax.swing.JTextField();
        jLabel16 = new javax.swing.JLabel();
        txtLocationAllowance = new javax.swing.JTextField();
        txtLocationStt = new javax.swing.JLabel();
        txtLocationID = new javax.swing.JLabel();
        jLabel11 = new javax.swing.JLabel();
        jPanelDepartment = new javax.swing.JPanel();
        jPanel7 = new javax.swing.JPanel();
        jLabel5 = new javax.swing.JLabel();
        txtSearchDepartment = new javax.swing.JTextField();
        btnSearchDepartment = new javax.swing.JButton();
        jLabel7 = new javax.swing.JLabel();
        cbSearchDepartment = new javax.swing.JComboBox();
        jPanel10 = new javax.swing.JPanel();
        jLabel17 = new javax.swing.JLabel();
        jLabel18 = new javax.swing.JLabel();
        txtDepartmentAllowance = new javax.swing.JTextField();
        jLabel19 = new javax.swing.JLabel();
        txtDepartmentName = new javax.swing.JTextField();
        jLabel20 = new javax.swing.JLabel();
        jLabel30 = new javax.swing.JLabel();
        txtDepartmentStt = new javax.swing.JLabel();
        txtDepartmentID = new javax.swing.JLabel();
        jPanelEmployee = new javax.swing.JPanel();
        jPanel13 = new javax.swing.JPanel();
        jLabel24 = new javax.swing.JLabel();
        txtSearchEmployeeID = new javax.swing.JTextField();
        jLabel25 = new javax.swing.JLabel();
        cbDepartmentSelect = new javax.swing.JComboBox();
        btnSearchEmployee = new javax.swing.JButton();
        cbLocationSelect = new javax.swing.JComboBox();
        cbProjectSelect = new javax.swing.JComboBox();
        cbSearchEmployee = new javax.swing.JComboBox();
        jPanel11 = new javax.swing.JPanel();
        txtSTTEmployee = new javax.swing.JTextField();
        txtEmployeeID = new javax.swing.JTextField();
        jLabel27 = new javax.swing.JLabel();
        jLabel35 = new javax.swing.JLabel();
        txtEmployeeName = new javax.swing.JTextField();
        jLabel39 = new javax.swing.JLabel();
        jLabel40 = new javax.swing.JLabel();
        jLabel33 = new javax.swing.JLabel();
        jLabel36 = new javax.swing.JLabel();
        jLabel37 = new javax.swing.JLabel();
        jLabel41 = new javax.swing.JLabel();
        txtEmail = new javax.swing.JTextField();
        jLabel38 = new javax.swing.JLabel();
        txtWorkEx = new javax.swing.JTextField();
        txtPassword = new javax.swing.JTextField();
        jLabel42 = new javax.swing.JLabel();
        jLabel43 = new javax.swing.JLabel();
        txtConfirmPassword = new javax.swing.JTextField();
        jLabel44 = new javax.swing.JLabel();
        cbEmployeeLocation = new javax.swing.JComboBox();
        jLabel45 = new javax.swing.JLabel();
        cbEmployeeProject = new javax.swing.JComboBox();
        jLabel46 = new javax.swing.JLabel();
        cbEmployeeDepartment = new javax.swing.JComboBox();
        jLabel47 = new javax.swing.JLabel();
        jButton32 = new javax.swing.JButton();
        txtPhoneNumber = new javax.swing.JTextField();
        txtAddress = new javax.swing.JTextField();
        jRadioButton1 = new javax.swing.JRadioButton();
        jRadioButton2 = new javax.swing.JRadioButton();
        jDateDayOfBirth = new com.toedter.calendar.JDateChooser();
        jButton25 = new javax.swing.JButton();
        jButton26 = new javax.swing.JButton();
        jButton27 = new javax.swing.JButton();
        jButton28 = new javax.swing.JButton();
        jPanelTransfer = new javax.swing.JPanel();
        jPanel12 = new javax.swing.JPanel();
        txtSearchTransferID = new javax.swing.JTextField();
        txtSearchTransferByEmployeeID = new javax.swing.JTextField();
        cbSearchTransferByToLocation = new javax.swing.JComboBox();
        jLabel48 = new javax.swing.JLabel();
        jLabel49 = new javax.swing.JLabel();
        jLabel56 = new javax.swing.JLabel();
        cbSearchTransferByCurrentLocation = new javax.swing.JComboBox();
        cbSearchTransferByToDepartment = new javax.swing.JComboBox();
        jLabel57 = new javax.swing.JLabel();
        jLabel58 = new javax.swing.JLabel();
        cbSearchTransferByCurrentDepartment = new javax.swing.JComboBox();
        cbSearchTransferByToProject = new javax.swing.JComboBox();
        jLabel59 = new javax.swing.JLabel();
        jLabel60 = new javax.swing.JLabel();
        cbSearchTransferByCurrentProject = new javax.swing.JComboBox();
        jLabel61 = new javax.swing.JLabel();
        cbSearchTransferByEmployeeName = new javax.swing.JComboBox();
        jLabel67 = new javax.swing.JLabel();
        btnSearchTransfer = new javax.swing.JButton();
        jPanel14 = new javax.swing.JPanel();
        txtTransferID = new javax.swing.JTextField();
        jLabel50 = new javax.swing.JLabel();
        txtEmployeeIDFromTransfer = new javax.swing.JTextField();
        jLabel51 = new javax.swing.JLabel();
        jLabel52 = new javax.swing.JLabel();
        cbTransferToLocation = new javax.swing.JComboBox();
        jLabel53 = new javax.swing.JLabel();
        cbTransferToDepartment = new javax.swing.JComboBox();
        jLabel54 = new javax.swing.JLabel();
        jLabel55 = new javax.swing.JLabel();
        cbTransferToProject = new javax.swing.JComboBox();
        jLabel62 = new javax.swing.JLabel();
        jLabel63 = new javax.swing.JLabel();
        jLabel64 = new javax.swing.JLabel();
        jLabel65 = new javax.swing.JLabel();
        jLabel66 = new javax.swing.JLabel();
        btnViewSearchTranfer = new javax.swing.JButton();
        ckStatus = new javax.swing.JCheckBox();
        jDateJoinDate = new com.toedter.calendar.JDateChooser();
        jDateEndDate = new com.toedter.calendar.JDateChooser();
        lblCurrentLocation = new javax.swing.JLabel();
        lblCurrentDepartment = new javax.swing.JLabel();
        lblCurrentProject = new javax.swing.JLabel();
        jButton14 = new javax.swing.JButton();
        jButton15 = new javax.swing.JButton();
        jButton16 = new javax.swing.JButton();
        jButton17 = new javax.swing.JButton();
        jToolBar2 = new javax.swing.JToolBar();
        jButton1 = new javax.swing.JButton();
        jSeparator1 = new javax.swing.JToolBar.Separator();
        jButton2 = new javax.swing.JButton();
        jSeparator2 = new javax.swing.JToolBar.Separator();
        jButton3 = new javax.swing.JButton();
        jSeparator3 = new javax.swing.JToolBar.Separator();
        jButton4 = new javax.swing.JButton();
        jSeparator4 = new javax.swing.JToolBar.Separator();
        jButton5 = new javax.swing.JButton();
        jMenuBar1 = new javax.swing.JMenuBar();
        jMenu1 = new javax.swing.JMenu();
        jMenuItem2 = new javax.swing.JMenuItem();
        jMenuItem3 = new javax.swing.JMenuItem();
        jMenuItem4 = new javax.swing.JMenuItem();
        jMenuItem5 = new javax.swing.JMenuItem();
        jMenu2 = new javax.swing.JMenu();
        jMenu3 = new javax.swing.JMenu();
        jMenu4 = new javax.swing.JMenu();
        jMenuItem7 = new javax.swing.JMenuItem();
        jMenuItem8 = new javax.swing.JMenuItem();
        jMenuItem9 = new javax.swing.JMenuItem();
        jMenuItem10 = new javax.swing.JMenuItem();
        jMenuItem11 = new javax.swing.JMenuItem();
        jMenu5 = new javax.swing.JMenu();
        jMenuItem6 = new javax.swing.JMenuItem();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        jToolBar1.setRollover(true);

        jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/Header.png"))); // NOI18N

        javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
        jPanel2.setLayout(jPanel2Layout);
        jPanel2Layout.setHorizontalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel2Layout.createSequentialGroup()
                .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 952, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(0, 10, Short.MAX_VALUE))
        );
        jPanel2Layout.setVerticalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jLabel1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );

        javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );

        jTabbedPane2.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        jTabbedPane2.setTabPlacement(javax.swing.JTabbedPane.LEFT);
        jTabbedPane2.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jTabbedPane2.setMinimumSize(new java.awt.Dimension(1067, 60));
        jTabbedPane2.setPreferredSize(new java.awt.Dimension(1000, 500));
        jTabbedPane2.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jTabbedPane2MouseClicked(evt);
            }
        });

        jPanel4.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Administrator Information", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, new java.awt.Color(0, 102, 0)));

        lblEmail.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        lblEmail.setText("Email");

        lblFullName.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        lblFullName.setText("Full Name");

        lblEmailText.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        lblEmailText.setForeground(new java.awt.Color(0, 102, 0));

        lblFullNameText.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        lblFullNameText.setForeground(new java.awt.Color(0, 102, 0));

        jLabel2.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel2.setText("Access Time");

        lbkDateText.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        lbkDateText.setForeground(new java.awt.Color(204, 0, 0));

        javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
        jPanel4.setLayout(jPanel4Layout);
        jPanel4Layout.setHorizontalGroup(
            jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel4Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel4Layout.createSequentialGroup()
                        .addComponent(lblEmail, javax.swing.GroupLayout.PREFERRED_SIZE, 46, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                    .addGroup(jPanel4Layout.createSequentialGroup()
                        .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                            .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel4Layout.createSequentialGroup()
                                .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(lblFullName)
                                    .addComponent(jLabel2))
                                .addGap(40, 40, 40)
                                .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(lblFullNameText, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                    .addComponent(lbkDateText, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
                            .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel4Layout.createSequentialGroup()
                                .addGap(110, 110, 110)
                                .addComponent(lblEmailText, javax.swing.GroupLayout.DEFAULT_SIZE, 485, Short.MAX_VALUE)))
                        .addGap(188, 188, 188))))
        );
        jPanel4Layout.setVerticalGroup(
            jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel4Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(lblEmail)
                    .addComponent(lblEmailText, javax.swing.GroupLayout.PREFERRED_SIZE, 14, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18)
                .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(lblFullName)
                    .addComponent(lblFullNameText, javax.swing.GroupLayout.PREFERRED_SIZE, 14, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18)
                .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel2)
                    .addComponent(lbkDateText, javax.swing.GroupLayout.PREFERRED_SIZE, 14, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Statistical ", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, new java.awt.Color(0, 102, 0)));

        jLabel21.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel21.setText("Total Transfer Approve:");

        jLabel22.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel22.setText("Total Transfer Not Approve:");

        lblTotalApprove.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        lblTotalApprove.setForeground(new java.awt.Color(0, 102, 0));
        lblTotalApprove.setText("jLabel28");

        lblTotalNotApprove.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        lblTotalNotApprove.setForeground(new java.awt.Color(0, 102, 0));
        lblTotalNotApprove.setText("jLabel29");

        btnViewDetaiTotalTransferApprovel.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/16x16/folder_full.png"))); // NOI18N
        btnViewDetaiTotalTransferApprovel.setText("View Detail");
        btnViewDetaiTotalTransferApprovel.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnViewDetaiTotalTransferApprovelActionPerformed(evt);
            }
        });

        btnViewDetailTotalTransferNotApprove.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/16x16/folder_full.png"))); // NOI18N
        btnViewDetailTotalTransferNotApprove.setText("View Detail");
        btnViewDetailTotalTransferNotApprove.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnViewDetailTotalTransferNotApproveActionPerformed(evt);
            }
        });

        btnViewDetailTotalTransfer.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/16x16/folder_full.png"))); // NOI18N
        btnViewDetailTotalTransfer.setText("View Detail");
        btnViewDetailTotalTransfer.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnViewDetailTotalTransferActionPerformed(evt);
            }
        });

        jLabel31.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel31.setText("Total Transfer:");

        lblTotalTransfer.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        lblTotalTransfer.setForeground(new java.awt.Color(0, 102, 0));
        lblTotalTransfer.setText("jLabel32");

        btnViewDetailTotalEmployee.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/16x16/folder_full.png"))); // NOI18N
        btnViewDetailTotalEmployee.setText("View Detail");
        btnViewDetailTotalEmployee.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnViewDetailTotalEmployeeActionPerformed(evt);
            }
        });

        lblTotalEmployee.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        lblTotalEmployee.setForeground(new java.awt.Color(0, 102, 0));
        lblTotalEmployee.setText("jLabel31");

        jLabel23.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel23.setText("Total Employee:");

        btnViewDetailTotalProject.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/16x16/folder_full.png"))); // NOI18N
        btnViewDetailTotalProject.setText("View Detail");
        btnViewDetailTotalProject.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnViewDetailTotalProjectActionPerformed(evt);
            }
        });

        lblTotalProject.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        lblTotalProject.setForeground(new java.awt.Color(0, 102, 0));
        lblTotalProject.setText("jLabel25");

        jLabel26.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel26.setText("Total Project:");

        btnViewDetailTotalLocation.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/16x16/folder_full.png"))); // NOI18N
        btnViewDetailTotalLocation.setText("View Detail");
        btnViewDetailTotalLocation.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnViewDetailTotalLocationActionPerformed(evt);
            }
        });

        lblTotalLocation.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        lblTotalLocation.setForeground(new java.awt.Color(0, 102, 0));
        lblTotalLocation.setText("jLabel27");

        jLabel32.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel32.setText("Total Location:");

        btnViewDetailTotalDepartment.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/16x16/folder_full.png"))); // NOI18N
        btnViewDetailTotalDepartment.setText("View Detail");
        btnViewDetailTotalDepartment.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnViewDetailTotalDepartmentActionPerformed(evt);
            }
        });

        lblTotalDepartment.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        lblTotalDepartment.setForeground(new java.awt.Color(0, 102, 0));
        lblTotalDepartment.setText("jLabel33");

        jLabel34.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel34.setText("Total Department:");

        javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
        jPanel3.setLayout(jPanel3Layout);
        jPanel3Layout.setHorizontalGroup(
            jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel3Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel21)
                    .addComponent(jLabel22)
                    .addComponent(jLabel31)
                    .addComponent(jLabel23)
                    .addComponent(jLabel26)
                    .addComponent(jLabel32)
                    .addComponent(jLabel34))
                .addGap(51, 51, 51)
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(lblTotalNotApprove, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(lblTotalTransfer, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(lblTotalEmployee, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(lblTotalProject, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(lblTotalLocation, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(lblTotalDepartment, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(lblTotalApprove, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addGap(39, 39, 39)
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(btnViewDetailTotalTransferNotApprove)
                    .addComponent(btnViewDetaiTotalTransferApprovel)
                    .addComponent(btnViewDetailTotalTransfer)
                    .addComponent(btnViewDetailTotalEmployee)
                    .addComponent(btnViewDetailTotalProject)
                    .addComponent(btnViewDetailTotalLocation)
                    .addComponent(btnViewDetailTotalDepartment))
                .addContainerGap(269, Short.MAX_VALUE))
        );
        jPanel3Layout.setVerticalGroup(
            jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel3Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(btnViewDetaiTotalTransferApprovel)
                    .addComponent(lblTotalApprove)
                    .addComponent(jLabel21))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel22)
                    .addComponent(lblTotalNotApprove)
                    .addComponent(btnViewDetailTotalTransferNotApprove))
                .addGap(5, 5, 5)
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(btnViewDetailTotalTransfer)
                    .addComponent(lblTotalTransfer)
                    .addComponent(jLabel31))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(btnViewDetailTotalEmployee)
                    .addComponent(lblTotalEmployee)
                    .addComponent(jLabel23))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(btnViewDetailTotalProject)
                    .addComponent(lblTotalProject)
                    .addComponent(jLabel26))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(btnViewDetailTotalLocation)
                    .addComponent(lblTotalLocation)
                    .addComponent(jLabel32))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(btnViewDetailTotalDepartment)
                    .addComponent(lblTotalDepartment)
                    .addComponent(jLabel34))
                .addContainerGap(64, Short.MAX_VALUE))
        );

        javax.swing.GroupLayout jPanelHomeLayout = new javax.swing.GroupLayout(jPanelHome);
        jPanelHome.setLayout(jPanelHomeLayout);
        jPanelHomeLayout.setHorizontalGroup(
            jPanelHomeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanelHomeLayout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanelHomeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jPanel4, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jPanel3, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addContainerGap())
        );
        jPanelHomeLayout.setVerticalGroup(
            jPanelHomeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanelHomeLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jPanel4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(jPanel3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(65, Short.MAX_VALUE))
        );

        jTabbedPane2.addTab("Home                                          ", new javax.swing.ImageIcon(getClass().getResource("/Icons/Home.png")), jPanelHome); // NOI18N

        jPanel5.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Search Information Project", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, new java.awt.Color(0, 102, 0)));

        jLabel3.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel3.setText("Enter Project ID:");

        txtSearchProjectID.setBackground(new java.awt.Color(255, 255, 204));

        btnSearchProject.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/16x16/search.png"))); // NOI18N
        btnSearchProject.setText("Search");
        btnSearchProject.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnSearchProjectActionPerformed(evt);
            }
        });

        jLabel6.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel6.setText("Project Name");

        cbSearchProject.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        javax.swing.GroupLayout jPanel5Layout = new javax.swing.GroupLayout(jPanel5);
        jPanel5.setLayout(jPanel5Layout);
        jPanel5Layout.setHorizontalGroup(
            jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel5Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel3)
                    .addComponent(jLabel6))
                .addGap(48, 48, 48)
                .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(txtSearchProjectID, javax.swing.GroupLayout.DEFAULT_SIZE, 392, Short.MAX_VALUE)
                    .addComponent(cbSearchProject, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addGap(18, 18, 18)
                .addComponent(btnSearchProject)
                .addContainerGap(32, Short.MAX_VALUE))
        );
        jPanel5Layout.setVerticalGroup(
            jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel5Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel3)
                    .addComponent(txtSearchProjectID, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(btnSearchProject))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel6)
                    .addComponent(cbSearchProject, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap(14, Short.MAX_VALUE))
        );

        jPanel15.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Information Project", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, new java.awt.Color(0, 102, 0)));

        jLabel9.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel9.setText("STT");

        jLabel12.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel12.setText("Project ID");

        txtProjectName.setEnabled(false);

        lblProjectName.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        lblProjectName.setText("ProjectName");

        txtProjectAllowance.setEnabled(false);

        jLabel68.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel68.setText("Work Exprience");

        jLabel10.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel10.setForeground(new java.awt.Color(0, 102, 0));

        javax.swing.GroupLayout jPanel15Layout = new javax.swing.GroupLayout(jPanel15);
        jPanel15.setLayout(jPanel15Layout);
        jPanel15Layout.setHorizontalGroup(
            jPanel15Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel15Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel15Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(lblProjectName)
                    .addComponent(jLabel12)
                    .addComponent(jLabel9)
                    .addComponent(jLabel68))
                .addGap(54, 54, 54)
                .addGroup(jPanel15Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(lblProjectStt, javax.swing.GroupLayout.PREFERRED_SIZE, 290, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGroup(jPanel15Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                        .addComponent(txtProjectName, javax.swing.GroupLayout.DEFAULT_SIZE, 393, Short.MAX_VALUE)
                        .addComponent(txtProjectAllowance)
                        .addComponent(lblProjectID, javax.swing.GroupLayout.PREFERRED_SIZE, 241, javax.swing.GroupLayout.PREFERRED_SIZE)))
                .addContainerGap(133, Short.MAX_VALUE))
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel15Layout.createSequentialGroup()
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(jLabel10, javax.swing.GroupLayout.PREFERRED_SIZE, 347, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(133, 133, 133))
        );
        jPanel15Layout.setVerticalGroup(
            jPanel15Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel15Layout.createSequentialGroup()
                .addGap(26, 26, 26)
                .addGroup(jPanel15Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(jLabel9, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(lblProjectStt, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addGap(18, 18, 18)
                .addGroup(jPanel15Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(jLabel12, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(lblProjectID, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanel15Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(txtProjectName, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(lblProjectName))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanel15Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(txtProjectAllowance, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel68))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 171, Short.MAX_VALUE)
                .addComponent(jLabel10)
                .addGap(32, 32, 32))
        );

        javax.swing.GroupLayout jPanelProjectLayout = new javax.swing.GroupLayout(jPanelProject);
        jPanelProject.setLayout(jPanelProjectLayout);
        jPanelProjectLayout.setHorizontalGroup(
            jPanelProjectLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanelProjectLayout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanelProjectLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jPanel5, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jPanel15, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addContainerGap())
        );
        jPanelProjectLayout.setVerticalGroup(
            jPanelProjectLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanelProjectLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jPanel15, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addGap(42, 42, 42))
        );

        jTabbedPane2.addTab("Project Management          ", new javax.swing.ImageIcon(getClass().getResource("/Icons/Folders.png")), jPanelProject); // NOI18N

        jPanel6.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Search Information Location", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, new java.awt.Color(0, 102, 0)));

        jLabel4.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel4.setText("Enter Location ID:");

        txtSearchLocation.setBackground(new java.awt.Color(255, 255, 204));

        btnSearchLocation.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/16x16/search.png"))); // NOI18N
        btnSearchLocation.setText("Search");
        btnSearchLocation.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnSearchLocationActionPerformed(evt);
            }
        });

        jLabel8.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel8.setText("Location Name:");

        cbSearchLocation.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        javax.swing.GroupLayout jPanel6Layout = new javax.swing.GroupLayout(jPanel6);
        jPanel6.setLayout(jPanel6Layout);
        jPanel6Layout.setHorizontalGroup(
            jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel6Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel4)
                    .addComponent(jLabel8))
                .addGap(41, 41, 41)
                .addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(txtSearchLocation, javax.swing.GroupLayout.DEFAULT_SIZE, 392, Short.MAX_VALUE)
                    .addComponent(cbSearchLocation, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addGap(18, 18, 18)
                .addComponent(btnSearchLocation)
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );
        jPanel6Layout.setVerticalGroup(
            jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel6Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel4)
                    .addComponent(txtSearchLocation, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(btnSearchLocation))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel8)
                    .addComponent(cbSearchLocation, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap(14, Short.MAX_VALUE))
        );

        jPanel8.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Information Location", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, new java.awt.Color(0, 102, 0)));

        jLabel13.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel13.setText("STT");

        jLabel14.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel14.setText("Location ID");

        jLabel15.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel15.setText("Location Name");

        txtLocationName.setBackground(new java.awt.Color(240, 240, 240));
        txtLocationName.setEnabled(false);

        jLabel16.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel16.setText("Location Allowance:");

        txtLocationAllowance.setBackground(new java.awt.Color(240, 240, 240));
        txtLocationAllowance.setEnabled(false);

        jLabel11.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel11.setForeground(new java.awt.Color(0, 102, 0));

        javax.swing.GroupLayout jPanel8Layout = new javax.swing.GroupLayout(jPanel8);
        jPanel8.setLayout(jPanel8Layout);
        jPanel8Layout.setHorizontalGroup(
            jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel8Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel13)
                    .addComponent(jLabel14)
                    .addComponent(jLabel16)
                    .addComponent(jLabel15))
                .addGap(32, 32, 32)
                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(txtLocationStt, javax.swing.GroupLayout.DEFAULT_SIZE, 391, Short.MAX_VALUE)
                    .addComponent(txtLocationID, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(txtLocationAllowance, javax.swing.GroupLayout.DEFAULT_SIZE, 391, Short.MAX_VALUE)
                    .addComponent(txtLocationName)
                    .addComponent(jLabel11, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 339, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap(134, Short.MAX_VALUE))
        );
        jPanel8Layout.setVerticalGroup(
            jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel8Layout.createSequentialGroup()
                .addGap(22, 22, 22)
                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel13)
                    .addComponent(txtLocationStt, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel14)
                    .addComponent(txtLocationID, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(txtLocationName, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel15))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(txtLocationAllowance, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel16))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 164, Short.MAX_VALUE)
                .addComponent(jLabel11)
                .addGap(33, 33, 33))
        );

        javax.swing.GroupLayout jPanelLocationLayout = new javax.swing.GroupLayout(jPanelLocation);
        jPanelLocation.setLayout(jPanelLocationLayout);
        jPanelLocationLayout.setHorizontalGroup(
            jPanelLocationLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanelLocationLayout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanelLocationLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jPanel6, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jPanel8, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addContainerGap())
        );
        jPanelLocationLayout.setVerticalGroup(
            jPanelLocationLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanelLocationLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jPanel6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(jPanel8, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addGap(42, 42, 42))
        );

        jTabbedPane2.addTab("Location Management            ", new javax.swing.ImageIcon(getClass().getResource("/Icons/earth_location.png")), jPanelLocation); // NOI18N

        jPanelDepartment.setPreferredSize(new java.awt.Dimension(761, 400));

        jPanel7.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Search Information Department", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, new java.awt.Color(0, 102, 0)));

        jLabel5.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel5.setText("Enter Department ID:");

        txtSearchDepartment.setBackground(new java.awt.Color(255, 255, 204));

        btnSearchDepartment.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/16x16/search.png"))); // NOI18N
        btnSearchDepartment.setText("Search");
        btnSearchDepartment.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnSearchDepartmentActionPerformed(evt);
            }
        });

        jLabel7.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel7.setText("Department Name:");

        cbSearchDepartment.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));
        cbSearchDepartment.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cbSearchDepartmentActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout jPanel7Layout = new javax.swing.GroupLayout(jPanel7);
        jPanel7.setLayout(jPanel7Layout);
        jPanel7Layout.setHorizontalGroup(
            jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel7Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel5)
                    .addComponent(jLabel7))
                .addGap(18, 18, 18)
                .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(txtSearchDepartment, javax.swing.GroupLayout.DEFAULT_SIZE, 392, Short.MAX_VALUE)
                    .addComponent(cbSearchDepartment, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addGap(18, 18, 18)
                .addComponent(btnSearchDepartment)
                .addContainerGap(149, Short.MAX_VALUE))
        );
        jPanel7Layout.setVerticalGroup(
            jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel7Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel5)
                    .addComponent(txtSearchDepartment, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(btnSearchDepartment))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel7)
                    .addComponent(cbSearchDepartment, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap(14, Short.MAX_VALUE))
        );

        jPanel10.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Information Department", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, new java.awt.Color(0, 102, 0)));

        jLabel17.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel17.setText("STT");

        jLabel18.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel18.setText("Deaprtment ID");

        txtDepartmentAllowance.setBackground(new java.awt.Color(240, 240, 240));
        txtDepartmentAllowance.setEnabled(false);

        jLabel19.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel19.setText("Department Name");

        txtDepartmentName.setBackground(new java.awt.Color(240, 240, 240));
        txtDepartmentName.setEnabled(false);

        jLabel20.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel20.setText("Department Allowance");

        jLabel30.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel30.setForeground(new java.awt.Color(0, 102, 0));

        javax.swing.GroupLayout jPanel10Layout = new javax.swing.GroupLayout(jPanel10);
        jPanel10.setLayout(jPanel10Layout);
        jPanel10Layout.setHorizontalGroup(
            jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel10Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel20)
                    .addComponent(jLabel19)
                    .addComponent(jLabel18)
                    .addComponent(jLabel17))
                .addGap(10, 10, 10)
                .addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(txtDepartmentStt, javax.swing.GroupLayout.PREFERRED_SIZE, 232, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtDepartmentID, javax.swing.GroupLayout.PREFERRED_SIZE, 149, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                        .addComponent(txtDepartmentAllowance, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 394, Short.MAX_VALUE)
                        .addComponent(txtDepartmentName, javax.swing.GroupLayout.Alignment.LEADING)
                        .addComponent(jLabel30, javax.swing.GroupLayout.PREFERRED_SIZE, 310, javax.swing.GroupLayout.PREFERRED_SIZE)))
                .addContainerGap(135, Short.MAX_VALUE))
        );
        jPanel10Layout.setVerticalGroup(
            jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel10Layout.createSequentialGroup()
                .addGap(22, 22, 22)
                .addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel17)
                    .addComponent(txtDepartmentStt, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel18)
                    .addComponent(txtDepartmentID, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(txtDepartmentName, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel19))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(txtDepartmentAllowance, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel20))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 150, Short.MAX_VALUE)
                .addComponent(jLabel30, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(24, 24, 24))
        );

        javax.swing.GroupLayout jPanelDepartmentLayout = new javax.swing.GroupLayout(jPanelDepartment);
        jPanelDepartment.setLayout(jPanelDepartmentLayout);
        jPanelDepartmentLayout.setHorizontalGroup(
            jPanelDepartmentLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanelDepartmentLayout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanelDepartmentLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jPanel7, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jPanel10, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addContainerGap())
        );
        jPanelDepartmentLayout.setVerticalGroup(
            jPanelDepartmentLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanelDepartmentLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jPanel7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(jPanel10, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addGap(42, 42, 42))
        );

        jTabbedPane2.addTab("Department Magement          ", new javax.swing.ImageIcon(getClass().getResource("/Icons/folder_full.png")), jPanelDepartment); // NOI18N

        jPanel13.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Search Information Employee", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, new java.awt.Color(0, 102, 0)));

        jLabel24.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel24.setText("Employee ID:");

        txtSearchEmployeeID.setBackground(new java.awt.Color(255, 255, 204));
        txtSearchEmployeeID.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                txtSearchEmployeeIDActionPerformed(evt);
            }
        });

        jLabel25.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel25.setText("Other:");

        cbDepartmentSelect.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));
        cbDepartmentSelect.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cbDepartmentSelectActionPerformed(evt);
            }
        });

        btnSearchEmployee.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/16x16/search.png"))); // NOI18N
        btnSearchEmployee.setText("Search");
        btnSearchEmployee.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnSearchEmployeeActionPerformed(evt);
            }
        });

        cbLocationSelect.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        cbProjectSelect.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));
        cbProjectSelect.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cbProjectSelectActionPerformed(evt);
            }
        });

        cbSearchEmployee.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        javax.swing.GroupLayout jPanel13Layout = new javax.swing.GroupLayout(jPanel13);
        jPanel13.setLayout(jPanel13Layout);
        jPanel13Layout.setHorizontalGroup(
            jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel13Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel24)
                    .addComponent(jLabel25))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(cbProjectSelect, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(txtSearchEmployeeID))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                    .addGroup(jPanel13Layout.createSequentialGroup()
                        .addComponent(cbLocationSelect, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(cbDepartmentSelect, javax.swing.GroupLayout.PREFERRED_SIZE, 139, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addComponent(cbSearchEmployee, javax.swing.GroupLayout.PREFERRED_SIZE, 279, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(btnSearchEmployee)
                .addContainerGap())
        );
        jPanel13Layout.setVerticalGroup(
            jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel13Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel24)
                    .addComponent(txtSearchEmployeeID, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(btnSearchEmployee)
                    .addComponent(cbSearchEmployee, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(cbDepartmentSelect, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel25)
                    .addComponent(cbLocationSelect, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(cbProjectSelect, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        jPanel11.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Information Employee ", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, new java.awt.Color(0, 102, 0)));

        txtSTTEmployee.setEnabled(false);

        txtEmployeeID.setEnabled(false);

        jLabel27.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel27.setText("STT");

        jLabel35.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel35.setText("Employee ID");

        txtEmployeeName.setEnabled(false);

        jLabel39.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel39.setText("Employee Name");

        jLabel40.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel40.setText("Gender");

        jLabel33.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel33.setText("Day Of Birth");

        jLabel36.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel36.setText("Phone Number");

        jLabel37.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel37.setText("Address");

        jLabel41.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel41.setForeground(new java.awt.Color(0, 102, 0));

        txtEmail.setEnabled(false);

        jLabel38.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel38.setText("Email");

        txtWorkEx.setEnabled(false);

        txtPassword.setEnabled(false);

        jLabel42.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel42.setText("Work Exprience");

        jLabel43.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel43.setText("Password");

        txtConfirmPassword.setEnabled(false);

        jLabel44.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel44.setText("Confirm Password");

        cbEmployeeLocation.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));
        cbEmployeeLocation.setEnabled(false);

        jLabel45.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel45.setText("Current Location");

        cbEmployeeProject.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));
        cbEmployeeProject.setEnabled(false);

        jLabel46.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel46.setText("Current Project");

        cbEmployeeDepartment.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));
        cbEmployeeDepartment.setEnabled(false);

        jLabel47.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel47.setText("Current Department");

        jButton32.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/16x16/folder_full.png"))); // NOI18N
        jButton32.setText("View All");
        jButton32.setEnabled(false);
        jButton32.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton32ActionPerformed(evt);
            }
        });

        txtPhoneNumber.setEnabled(false);

        txtAddress.setEnabled(false);

        buttonGroup1.add(jRadioButton1);
        jRadioButton1.setText("Male");
        jRadioButton1.setEnabled(false);

        buttonGroup1.add(jRadioButton2);
        jRadioButton2.setText("Female");
        jRadioButton2.setEnabled(false);

        jDateDayOfBirth.setEnabled(false);

        javax.swing.GroupLayout jPanel11Layout = new javax.swing.GroupLayout(jPanel11);
        jPanel11.setLayout(jPanel11Layout);
        jPanel11Layout.setHorizontalGroup(
            jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel11Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel27)
                    .addComponent(jLabel35)
                    .addComponent(jLabel39)
                    .addComponent(jLabel40)
                    .addComponent(jLabel33)
                    .addComponent(jLabel36)
                    .addComponent(jLabel37))
                .addGap(24, 24, 24)
                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel11Layout.createSequentialGroup()
                        .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                            .addComponent(txtSTTEmployee)
                            .addComponent(txtEmployeeID)
                            .addComponent(txtEmployeeName, javax.swing.GroupLayout.Alignment.TRAILING)
                            .addComponent(txtPhoneNumber)
                            .addComponent(txtAddress)
                            .addGroup(jPanel11Layout.createSequentialGroup()
                                .addComponent(jRadioButton1)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 55, Short.MAX_VALUE)
                                .addComponent(jRadioButton2))
                            .addComponent(jDateDayOfBirth, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jLabel45)
                            .addComponent(jLabel46)
                            .addComponent(jLabel47)
                            .addComponent(jLabel44)
                            .addComponent(jLabel43)
                            .addComponent(jLabel42)
                            .addComponent(jLabel38))
                        .addGap(24, 24, 24)
                        .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                            .addComponent(txtEmail, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 180, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(txtWorkEx, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 180, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(txtPassword, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 180, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(txtConfirmPassword, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 180, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(cbEmployeeDepartment, javax.swing.GroupLayout.Alignment.TRAILING, 0, 209, Short.MAX_VALUE)
                            .addComponent(cbEmployeeProject, javax.swing.GroupLayout.Alignment.TRAILING, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(cbEmployeeLocation, javax.swing.GroupLayout.Alignment.TRAILING, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
                    .addGroup(jPanel11Layout.createSequentialGroup()
                        .addGap(0, 59, Short.MAX_VALUE)
                        .addComponent(jLabel41, javax.swing.GroupLayout.PREFERRED_SIZE, 392, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jButton32)))
                .addContainerGap())
        );
        jPanel11Layout.setVerticalGroup(
            jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel11Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(txtSTTEmployee, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel27)
                    .addComponent(txtEmail, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel38))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(txtEmployeeID, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel35)
                    .addComponent(txtWorkEx, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel42))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(txtEmployeeName, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel39)
                    .addComponent(txtPassword, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel43))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel40)
                    .addComponent(txtConfirmPassword, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel44)
                    .addComponent(jRadioButton1)
                    .addComponent(jRadioButton2))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel33)
                        .addComponent(cbEmployeeLocation, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel45))
                    .addComponent(jDateDayOfBirth, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel36)
                    .addComponent(cbEmployeeProject, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel46)
                    .addComponent(txtPhoneNumber, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel37)
                    .addComponent(cbEmployeeDepartment, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel47)
                    .addComponent(txtAddress, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18)
                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jButton32)
                    .addComponent(jLabel41, javax.swing.GroupLayout.PREFERRED_SIZE, 22, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap(100, Short.MAX_VALUE))
        );

        jButton25.setText("<<");
        jButton25.setEnabled(false);
        jButton25.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton25ActionPerformed(evt);
            }
        });

        jButton26.setText("<");
        jButton26.setEnabled(false);
        jButton26.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton26ActionPerformed(evt);
            }
        });

        jButton27.setText(">");
        jButton27.setEnabled(false);
        jButton27.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton27ActionPerformed(evt);
            }
        });

        jButton28.setText(">>");
        jButton28.setEnabled(false);
        jButton28.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton28ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout jPanelEmployeeLayout = new javax.swing.GroupLayout(jPanelEmployee);
        jPanelEmployee.setLayout(jPanelEmployeeLayout);
        jPanelEmployeeLayout.setHorizontalGroup(
            jPanelEmployeeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanelEmployeeLayout.createSequentialGroup()
                .addGap(31, 31, 31)
                .addComponent(jButton25)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jButton26)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jButton27)
                .addGap(10, 10, 10)
                .addComponent(jButton28)
                .addGap(52, 477, Short.MAX_VALUE))
            .addGroup(jPanelEmployeeLayout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanelEmployeeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jPanel13, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jPanel11, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addContainerGap())
        );
        jPanelEmployeeLayout.setVerticalGroup(
            jPanelEmployeeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanelEmployeeLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jPanel13, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jPanel11, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addGap(8, 8, 8)
                .addGroup(jPanelEmployeeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButton28)
                    .addComponent(jButton27)
                    .addComponent(jButton26)
                    .addComponent(jButton25))
                .addContainerGap())
        );

        jTabbedPane2.addTab("Employee Management        ", new javax.swing.ImageIcon(getClass().getResource("/Icons/Buddy Group.png")), jPanelEmployee); // NOI18N

        jPanelTransfer.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
        jPanelTransfer.setPreferredSize(new java.awt.Dimension(847, 500));
        jPanelTransfer.setRequestFocusEnabled(false);

        jPanel12.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Search Information Transfer", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, new java.awt.Color(0, 102, 0)));

        txtSearchTransferID.setBackground(new java.awt.Color(255, 255, 204));
        txtSearchTransferID.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                txtSearchTransferIDMouseClicked(evt);
            }
        });

        txtSearchTransferByEmployeeID.setBackground(new java.awt.Color(255, 255, 204));

        cbSearchTransferByToLocation.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jLabel48.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel48.setText("Transfer ID");

        jLabel49.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel49.setText("EmployeeID");

        jLabel56.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel56.setText("Employee Name");

        cbSearchTransferByCurrentLocation.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        cbSearchTransferByToDepartment.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jLabel57.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel57.setText("To Location");

        jLabel58.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel58.setText("Current Location");

        cbSearchTransferByCurrentDepartment.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        cbSearchTransferByToProject.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jLabel59.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel59.setText("To Department");

        jLabel60.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel60.setText("Current Department");

        cbSearchTransferByCurrentProject.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jLabel61.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel61.setText("Current Project");

        cbSearchTransferByEmployeeName.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jLabel67.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel67.setText("To Project");

        btnSearchTransfer.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/16x16/search.png"))); // NOI18N
        btnSearchTransfer.setText("Search");
        btnSearchTransfer.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnSearchTransferActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout jPanel12Layout = new javax.swing.GroupLayout(jPanel12);
        jPanel12.setLayout(jPanel12Layout);
        jPanel12Layout.setHorizontalGroup(
            jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel12Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel48)
                    .addComponent(jLabel49)
                    .addComponent(jLabel58)
                    .addComponent(jLabel60)
                    .addComponent(jLabel61))
                .addGap(18, 18, 18)
                .addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel12Layout.createSequentialGroup()
                        .addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(cbSearchTransferByCurrentProject, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(cbSearchTransferByCurrentDepartment, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(cbSearchTransferByCurrentLocation, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(txtSearchTransferByEmployeeID))
                        .addGap(18, 18, 18)
                        .addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jLabel56)
                            .addComponent(jLabel57)
                            .addComponent(jLabel59)
                            .addComponent(jLabel67))
                        .addGap(18, 18, 18)
                        .addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                            .addComponent(cbSearchTransferByToLocation, javax.swing.GroupLayout.Alignment.TRAILING, 0, 205, Short.MAX_VALUE)
                            .addComponent(cbSearchTransferByToDepartment, javax.swing.GroupLayout.Alignment.TRAILING, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(cbSearchTransferByToProject, javax.swing.GroupLayout.Alignment.TRAILING, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(cbSearchTransferByEmployeeName, javax.swing.GroupLayout.Alignment.TRAILING, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
                    .addGroup(jPanel12Layout.createSequentialGroup()
                        .addComponent(txtSearchTransferID, javax.swing.GroupLayout.PREFERRED_SIZE, 412, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 28, Short.MAX_VALUE)
                        .addComponent(btnSearchTransfer)))
                .addContainerGap())
        );
        jPanel12Layout.setVerticalGroup(
            jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel12Layout.createSequentialGroup()
                .addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel48)
                    .addComponent(txtSearchTransferID, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(btnSearchTransfer))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(txtSearchTransferByEmployeeID, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel49)
                    .addComponent(jLabel56)
                    .addComponent(cbSearchTransferByEmployeeName, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(cbSearchTransferByCurrentLocation, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel57)
                    .addComponent(jLabel58)
                    .addComponent(cbSearchTransferByToLocation, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(cbSearchTransferByCurrentDepartment, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel59)
                    .addComponent(jLabel60)
                    .addComponent(cbSearchTransferByToDepartment, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(cbSearchTransferByCurrentProject, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel61)
                    .addComponent(cbSearchTransferByToProject, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel67))
                .addContainerGap())
        );

        jPanel14.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Information Transfer", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, new java.awt.Color(0, 102, 0)));

        txtTransferID.setEnabled(false);

        jLabel50.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel50.setText("Transfer ID");

        txtEmployeeIDFromTransfer.setEnabled(false);

        jLabel51.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel51.setText("EmployeeID");

        jLabel52.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel52.setText("Current Location");

        cbTransferToLocation.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));
        cbTransferToLocation.setEnabled(false);

        jLabel53.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel53.setText("To Location");

        cbTransferToDepartment.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));
        cbTransferToDepartment.setEnabled(false);

        jLabel54.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel54.setText("To Department");

        jLabel55.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel55.setText("Current Department");

        cbTransferToProject.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));
        cbTransferToProject.setEnabled(false);

        jLabel62.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel62.setText("To Project");

        jLabel63.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel63.setText("Current Project");

        jLabel64.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel64.setText("Join Date");

        jLabel65.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel65.setText("End Date");

        jLabel66.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jLabel66.setForeground(new java.awt.Color(0, 102, 0));

        btnViewSearchTranfer.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/16x16/folder_full.png"))); // NOI18N
        btnViewSearchTranfer.setText("View All");
        btnViewSearchTranfer.setEnabled(false);
        btnViewSearchTranfer.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnViewSearchTranferActionPerformed(evt);
            }
        });

        ckStatus.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        ckStatus.setText("Status");
        ckStatus.setEnabled(false);

        jDateJoinDate.setEnabled(false);

        jDateEndDate.setEnabled(false);

        javax.swing.GroupLayout jPanel14Layout = new javax.swing.GroupLayout(jPanel14);
        jPanel14.setLayout(jPanel14Layout);
        jPanel14Layout.setHorizontalGroup(
            jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel14Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel14Layout.createSequentialGroup()
                        .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel14Layout.createSequentialGroup()
                                .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                                    .addComponent(jLabel50)
                                    .addComponent(jLabel52, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addComponent(jLabel55, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                    .addComponent(jLabel63, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                                .addGap(16, 16, 16))
                            .addGroup(jPanel14Layout.createSequentialGroup()
                                .addComponent(jLabel64)
                                .addGap(78, 78, 78)))
                        .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                            .addComponent(txtTransferID)
                            .addComponent(jDateJoinDate, javax.swing.GroupLayout.DEFAULT_SIZE, 195, Short.MAX_VALUE)
                            .addComponent(lblCurrentProject, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(lblCurrentDepartment, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(lblCurrentLocation, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 21, Short.MAX_VALUE)
                        .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jLabel53)
                            .addComponent(jLabel51)
                            .addComponent(jLabel54)
                            .addComponent(jLabel62)
                            .addComponent(jLabel65))
                        .addGap(20, 20, 20)
                        .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                            .addComponent(cbTransferToProject, 0, 205, Short.MAX_VALUE)
                            .addComponent(cbTransferToDepartment, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(txtEmployeeIDFromTransfer)
                            .addComponent(jDateEndDate, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(cbTransferToLocation, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
                    .addGroup(jPanel14Layout.createSequentialGroup()
                        .addComponent(ckStatus)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addComponent(jLabel66, javax.swing.GroupLayout.PREFERRED_SIZE, 368, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(18, 18, 18)
                        .addComponent(btnViewSearchTranfer)))
                .addContainerGap())
        );
        jPanel14Layout.setVerticalGroup(
            jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel14Layout.createSequentialGroup()
                .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(txtTransferID, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel50)
                    .addComponent(txtEmployeeIDFromTransfer, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel51))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(lblCurrentLocation, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel52)
                        .addComponent(cbTransferToLocation, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel53)))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(cbTransferToDepartment, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel54)
                    .addComponent(jLabel55)
                    .addComponent(lblCurrentDepartment))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(cbTransferToProject, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel62)
                    .addComponent(jLabel63)
                    .addComponent(lblCurrentProject))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jDateJoinDate, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jDateEndDate, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel65, javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(jLabel64, javax.swing.GroupLayout.Alignment.TRAILING))
                .addGap(18, 18, 18)
                .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(ckStatus)
                    .addComponent(jLabel66, javax.swing.GroupLayout.PREFERRED_SIZE, 24, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(btnViewSearchTranfer))
                .addGap(0, 108, Short.MAX_VALUE))
        );

        jButton14.setText("<<");
        jButton14.setEnabled(false);
        jButton14.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton14ActionPerformed(evt);
            }
        });

        jButton15.setText("<");
        jButton15.setEnabled(false);
        jButton15.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton15ActionPerformed(evt);
            }
        });

        jButton16.setText(">");
        jButton16.setEnabled(false);
        jButton16.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton16ActionPerformed(evt);
            }
        });

        jButton17.setText(">>");
        jButton17.setEnabled(false);
        jButton17.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton17ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout jPanelTransferLayout = new javax.swing.GroupLayout(jPanelTransfer);
        jPanelTransfer.setLayout(jPanelTransferLayout);
        jPanelTransferLayout.setHorizontalGroup(
            jPanelTransferLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanelTransferLayout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanelTransferLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jPanel12, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jPanel14, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addContainerGap())
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanelTransferLayout.createSequentialGroup()
                .addGap(42, 42, 42)
                .addComponent(jButton14)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jButton15)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jButton16)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jButton17)
                .addGap(50, 470, Short.MAX_VALUE))
        );
        jPanelTransferLayout.setVerticalGroup(
            jPanelTransferLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanelTransferLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jPanel12, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jPanel14, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanelTransferLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButton14)
                    .addComponent(jButton15)
                    .addComponent(jButton16)
                    .addComponent(jButton17))
                .addContainerGap())
        );

        jTabbedPane2.addTab("Transfer Management             ", new javax.swing.ImageIcon(getClass().getResource("/Icons/refresh.png")), jPanelTransfer); // NOI18N

        jToolBar2.setRollover(true);

        jButton1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/24x24/password.png"))); // NOI18N
        jButton1.setFocusable(false);
        jButton1.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
        jButton1.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });
        jToolBar2.add(jButton1);
        jToolBar2.add(jSeparator1);

        jButton2.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/24x24/info.png"))); // NOI18N
        jButton2.setFocusable(false);
        jButton2.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
        jButton2.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });
        jToolBar2.add(jButton2);
        jToolBar2.add(jSeparator2);

        jButton3.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/24x24/help.png"))); // NOI18N
        jButton3.setFocusable(false);
        jButton3.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
        jButton3.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
        jButton3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton3ActionPerformed(evt);
            }
        });
        jToolBar2.add(jButton3);
        jToolBar2.add(jSeparator3);

        jButton4.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/login (24 x 24).png"))); // NOI18N
        jButton4.setFocusable(false);
        jButton4.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
        jButton4.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
        jButton4.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton4ActionPerformed(evt);
            }
        });
        jToolBar2.add(jButton4);
        jToolBar2.add(jSeparator4);

        jButton5.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/24x24/logout.png"))); // NOI18N
        jButton5.setFocusable(false);
        jButton5.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
        jButton5.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
        jButton5.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton5ActionPerformed(evt);
            }
        });
        jToolBar2.add(jButton5);

        jMenu1.setText("File");

        jMenuItem2.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_P, java.awt.event.InputEvent.CTRL_MASK));
        jMenuItem2.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/24x24/password.png"))); // NOI18N
        jMenuItem2.setText("Change PassWord...");
        jMenuItem2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem2ActionPerformed(evt);
            }
        });
        jMenu1.add(jMenuItem2);

        jMenuItem3.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_O, java.awt.event.InputEvent.CTRL_MASK));
        jMenuItem3.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/login (24 x 24).png"))); // NOI18N
        jMenuItem3.setText("Sign Out");
        jMenuItem3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem3ActionPerformed(evt);
            }
        });
        jMenu1.add(jMenuItem3);

        jMenuItem4.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_X, java.awt.event.InputEvent.CTRL_MASK));
        jMenuItem4.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/24x24/logout.png"))); // NOI18N
        jMenuItem4.setText("Exit");
        jMenuItem4.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem4ActionPerformed(evt);
            }
        });
        jMenu1.add(jMenuItem4);

        jMenuItem5.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_F5, 0));
        jMenuItem5.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/24x24/refresh.png"))); // NOI18N
        jMenuItem5.setText("Refresh");
        jMenuItem5.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem5ActionPerformed(evt);
            }
        });
        jMenu1.add(jMenuItem5);

        jMenuBar1.add(jMenu1);

        jMenu2.setText("Edit");
        jMenuBar1.add(jMenu2);

        jMenu3.setText("Insert");
        jMenuBar1.add(jMenu3);

        jMenu4.setText("View");

        jMenuItem7.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_F6, 0));
        jMenuItem7.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/24x24/chart.png"))); // NOI18N
        jMenuItem7.setText("Project...");
        jMenuItem7.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem7ActionPerformed(evt);
            }
        });
        jMenu4.add(jMenuItem7);

        jMenuItem8.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_F7, 0));
        jMenuItem8.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/24x24/chart_pie.png"))); // NOI18N
        jMenuItem8.setText("Location...");
        jMenuItem8.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem8ActionPerformed(evt);
            }
        });
        jMenu4.add(jMenuItem8);

        jMenuItem9.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_F8, 0));
        jMenuItem9.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/24x24/folder_full.png"))); // NOI18N
        jMenuItem9.setText("Department...");
        jMenuItem9.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem9ActionPerformed(evt);
            }
        });
        jMenu4.add(jMenuItem9);

        jMenuItem10.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_F9, 0));
        jMenuItem10.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/24x24/Buddy.png"))); // NOI18N
        jMenuItem10.setText("Employee...");
        jMenuItem10.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem10ActionPerformed(evt);
            }
        });
        jMenu4.add(jMenuItem10);

        jMenuItem11.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_F10, 0));
        jMenuItem11.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/24x24/refresh.png"))); // NOI18N
        jMenuItem11.setText("Transfer...");
        jMenu4.add(jMenuItem11);

        jMenuBar1.add(jMenu4);

        jMenu5.setText("Help");

        jMenuItem6.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_F12, 0));
        jMenuItem6.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Icons/24x24/info.png"))); // NOI18N
        jMenuItem6.setText("About");
        jMenuItem6.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem6ActionPerformed(evt);
            }
        });
        jMenu5.add(jMenuItem6);

        jMenuBar1.add(jMenu5);

        setJMenuBar(jMenuBar1);

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jToolBar2, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.PREFERRED_SIZE, 950, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(jToolBar1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
            .addGroup(layout.createSequentialGroup()
                .addComponent(jTabbedPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 952, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(0, 0, Short.MAX_VALUE))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jToolBar1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jToolBar2, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jTabbedPane2, javax.swing.GroupLayout.DEFAULT_SIZE, 527, Short.MAX_VALUE)
                .addContainerGap())
        );

        jTabbedPane2.getAccessibleContext().setAccessibleName("Home");

        pack();
    }// </editor-fold>//GEN-END:initComponents
    public void loadMenu(){
        jMenu1.setMnemonic(KeyEvent.VK_F);
        jMenu2.setMnemonic(KeyEvent.VK_E);
        jMenu3.setMnemonic(KeyEvent.VK_S);
        jMenu4.setMnemonic(KeyEvent.VK_V);
        jMenu5.setMnemonic(KeyEvent.VK_H);
        jMenuItem2.setMnemonic(KeyEvent.VK_W);
        jMenuItem3.setMnemonic(KeyEvent.VK_O);
        jMenuItem4.setMnemonic(KeyEvent.VK_X);
    }
    
    private void requesSearchTransfer(){
        txtSearchTransferID.setText("");
        txtSearchTransferByEmployeeID.setText("");
        cbSearchTransferByEmployeeName.setSelectedIndex(0);
        cbSearchTransferByCurrentLocation.setSelectedIndex(0);
        cbSearchTransferByCurrentDepartment.setSelectedIndex(0);
        cbSearchTransferByCurrentProject.setSelectedIndex(0);
        cbSearchTransferByToLocation.setSelectedIndex(0);
        cbSearchTransferByToDepartment.setSelectedIndex(0);
        cbSearchTransferByToProject.setSelectedIndex(0);
    }
    
    private void resetSearchTransfer(){
        txtTransferID.setText("");
        txtEmployeeIDFromTransfer.setText("");
        lblCurrentDepartment.setText("");
        lblCurrentLocation.setText("");
        lblCurrentProject.setText("");
        cbTransferToDepartment.setSelectedIndex(0);
        cbTransferToLocation.setSelectedIndex(0);
        cbTransferToProject.setSelectedIndex(0);
        jDateJoinDate.setDate(null);
        jDateEndDate.setDate(null);
        ckStatus.setSelected(false);
        
        txtTransferID.setEnabled(false);
        txtEmployeeIDFromTransfer.setEnabled(false);
        cbTransferToDepartment.setEnabled(false);
        cbTransferToLocation.setEnabled(false);
        cbTransferToProject.setEnabled(false);
        jDateEndDate.setEnabled(false);
        jDateJoinDate.setEnabled(false);
        ckStatus.setEnabled(false);
        btnViewSearchTranfer.setEnabled(false);
        jLabel66.setText("");
    }
    
    private void enableSearchTransfer(){
        try {
            rsTransfer.first();
            txtTransferID.setText(rsTransfer.getString(2));
            txtEmployeeIDFromTransfer.setText(rsTransfer.getString(3));
            lblCurrentProject.setText(ProjectDAO.getProjectName(rsTransfer.getString(4)));
            cbTransferToProject.setSelectedItem(ProjectDAO.getProjectName(rsTransfer.getString(5)));
            lblCurrentDepartment.setText(DepartmentDAO.getDepartmentName(rsTransfer.getString(6)));
            cbTransferToDepartment.setSelectedItem(DepartmentDAO.getDepartmentName(rsTransfer.getString(7)));
            lblCurrentLocation.setText(LocationDAO.getLocationName(rsTransfer.getString(8)));
            cbTransferToLocation.setSelectedItem(LocationDAO.getLocationName(rsTransfer.getString(9)));
            jDateJoinDate.setDate(rsTransfer.getDate(10));
            jDateEndDate.setDate(rsTransfer.getDate(11));
            ckStatus.setSelected(rsTransfer.getBoolean(12));
                    
            ckStatus.setEnabled(true);
            jDateEndDate.setEnabled(true);
            jDateJoinDate.setEnabled(true);
            cbTransferToLocation.setEnabled(true);
            cbTransferToDepartment.setEnabled(true);
            cbTransferToProject.setEnabled(true);
            txtTransferID.setEnabled(true);
            txtEmployeeIDFromTransfer.setEnabled(true);
            btnViewSearchTranfer.setEnabled(true);
            jButton14.setEnabled(false);
            jButton15.setEnabled(false);
            jButton16.setEnabled(false);
            jButton17.setEnabled(false);
      } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }   
    }
    
    public void travelTransfer(){
        try {
            txtTransferID.setText(rsTransfer.getString(2));
            txtEmployeeIDFromTransfer.setText(rsTransfer.getString(3));
            lblCurrentProject.setText(ProjectDAO.getProjectName(rsTransfer.getString(4)));
            cbTransferToProject.setSelectedItem(ProjectDAO.getProjectName(rsTransfer.getString(5)));
            lblCurrentDepartment.setText(DepartmentDAO.getDepartmentName(rsTransfer.getString(6)));
            cbTransferToDepartment.setSelectedItem(DepartmentDAO.getDepartmentName(rsTransfer.getString(7)));
            lblCurrentLocation.setText(LocationDAO.getLocationName(rsTransfer.getString(8)));
            cbTransferToLocation.setSelectedItem(LocationDAO.getLocationName(rsTransfer.getString(9)));
            jDateJoinDate.setDate(rsTransfer.getDate(10));
            jDateEndDate.setDate(rsTransfer.getDate(11));
            ckStatus.setSelected(rsTransfer.getBoolean(12));
            
            ckStatus.setEnabled(true);
            jDateEndDate.setEnabled(true);
            jDateJoinDate.setEnabled(true);
            cbTransferToLocation.setEnabled(true);
            cbTransferToDepartment.setEnabled(true);
            cbTransferToProject.setEnabled(true);
            txtTransferID.setEnabled(true);
            txtEmployeeIDFromTransfer.setEnabled(true);
            btnViewSearchTranfer.setEnabled(true);
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }       
    }
    
    private void resetSearchEmployee(){
        txtSearchEmployeeID.setText("");
        cbDepartmentSelect.setSelectedIndex(0);
        txtSTTEmployee.setText("");
        txtEmployeeID.setText("");
        txtEmployeeName.setText("");
        jRadioButton1.setSelected(true); 
        txtPhoneNumber.setText("");
        txtAddress.setText("");
        txtEmail.setText("");
        txtWorkEx.setText("");
        txtPassword.setText("");
        txtConfirmPassword.setText("");
        cbEmployeeLocation.setSelectedIndex(0);
        cbEmployeeDepartment.setSelectedIndex(0);
        cbEmployeeProject.setSelectedIndex(0);
                
        txtSTTEmployee.setEnabled(false);
        txtEmployeeID.setEnabled(false);
        txtEmployeeName.setEnabled(false);
        jDateDayOfBirth.setEnabled(true);
        jRadioButton1.setEnabled(false);
        jRadioButton2.setEnabled(false);
        txtPhoneNumber.setEnabled(false);
        txtAddress.setEnabled(false);
        txtEmail.setEnabled(false);
        txtWorkEx.setEnabled(false);
        txtPassword.setEnabled(false);
        txtConfirmPassword.setEnabled(false);
        cbEmployeeLocation.setEnabled(false);
        cbEmployeeDepartment.setEnabled(false);
        cbEmployeeProject.setEnabled(false);
        jButton25.setEnabled(false);
        jButton26.setEnabled(false);
        jButton27.setEnabled(false);
        jButton28.setEnabled(false);
        jButton32.setEnabled(false);
        jDateDayOfBirth.setEnabled(false);
        cbSearchEmployee.setSelectedIndex(0);
        cbProjectSelect.setSelectedIndex(0);
        cbLocationSelect.setSelectedIndex(0);
        cbDepartmentSelect.setSelectedIndex(0);
    }
    
    public void resultEmployee() throws SQLException{
        txtSTTEmployee.setText(rsEmployee.getString(1));
        txtEmployeeID.setText(rsEmployee.getString(2));
        txtEmployeeName.setText(rsEmployee.getString(3));
                                //jLabel41.setText(rsEmployee.getString(4));
        if (Integer.parseInt(rsEmployee.getString(4)) == 1) {
            jRadioButton1.setSelected(true);
            jRadioButton2.setSelected(false);
        } else {
            jRadioButton1.setSelected(false);
            jRadioButton2.setSelected(true);
        }
        jDateDayOfBirth.setDate(rsEmployee.getDate(5));
        txtPhoneNumber.setText(rsEmployee.getString(6));
        txtAddress.setText(rsEmployee.getString(7));
        txtEmail.setText(rsEmployee.getString(8));
        txtPassword.setText(rsEmployee.getString(9));
        txtConfirmPassword.setText(rsEmployee.getString(9));
        txtWorkEx.setText(rsEmployee.getString(10));
        cbEmployeeLocation.setSelectedItem(LocationDAO.getLocationName(rsEmployee.getString(11)));
        cbEmployeeDepartment.setSelectedItem(DepartmentDAO.getDepartmentName(rsEmployee.getString(12)));
        cbEmployeeProject.setSelectedItem(ProjectDAO.getProjectName(rsEmployee.getString(13)));

        txtSTTEmployee.setEnabled(true);
        txtEmployeeID.setEnabled(true);
        txtEmployeeName.setEnabled(true);
        jDateDayOfBirth.setEnabled(true);
        //txtDayOfBirth.setEnabled(true);
        txtPhoneNumber.setEnabled(true);
        txtAddress.setEnabled(true);
        txtEmail.setEnabled(true);
        txtWorkEx.setEnabled(true);
        txtPassword.setEnabled(true);
        txtConfirmPassword.setEnabled(true);
        cbEmployeeLocation.setEnabled(true);
        cbEmployeeDepartment.setEnabled(true);
        cbEmployeeProject.setEnabled(true);
        jRadioButton1.setEnabled(true);
        jRadioButton2.setEnabled(true);
        jButton32.setEnabled(true);
    }
    private int countSearchTransfer(){
        int count = 0;
        try {
            while(rsTransfer.next()){
                count++;
            }
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
        return count;
    }
    
    public void dontSee(){
        int count = 0;
        try {
            while(rsTransfer.next()){
                count++;
            }
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
        if (count == 0) {
            JOptionPane.showMessageDialog(null, "Don't See");
            resetSearchTransfer();
            requesSearchTransfer();
        } else if (count == 1) {
            enableSearchTransfer();
            requesSearchTransfer();
            jButton14.setEnabled(false);
            jButton15.setEnabled(false);
            jButton16.setEnabled(false);
            jButton17.setEnabled(false);
        } else{
            enableSearchTransfer();
            requesSearchTransfer();
            jButton14.setEnabled(true);
            jButton15.setEnabled(true);
            jButton16.setEnabled(true);
            jButton17.setEnabled(true);
        }
    }
    
    public void loadEmployee(Employee objEmployee) {
        Date todayDate = new Date(System.currentTimeMillis());
        SimpleDateFormat dayFormat = new SimpleDateFormat("dd/MM/yyy 'at' hh:mm:ss ");
        String todayString = dayFormat.format(todayDate.getTime());
        //oldPass = objAdmin.getPassword();
        lblEmailText.setText(objEmployee.getEmail());
        lblFullNameText.setText(objEmployee.getEmployeeName());
        lbkDateText.setText(todayString);
    }
    
    public void loadStatistical() throws SQLException{
        String totalApprove = String.valueOf(TransferDAO.countTotalTransferApprove());
        String totalNotApprove = String.valueOf(TransferDAO.countTotalTranferNotApprove());
        String totalTransfer = String.valueOf(TransferDAO.countTotalTransfer());
        String totalEmployee = String.valueOf(EmployeeDAO.countTotalEmployee());
        String totalProject = String.valueOf(ProjectDAO.countTotalProject());
        String totalLocation = String.valueOf(LocationDAO.countTotalLocation());
        String totalDepartment = String.valueOf(DepartmentDAO.countTotalDepartmetn());
        
        lblTotalApprove.setText(totalApprove);
        lblTotalNotApprove.setText(totalNotApprove);
        lblTotalTransfer.setText(totalTransfer);
        lblTotalEmployee.setText(totalEmployee);
        lblTotalProject.setText(totalProject);
        lblTotalLocation.setText(totalLocation);
        lblTotalDepartment.setText(totalDepartment);
    }
    public void loadDepartmentSelect() throws SQLException{
        Vector v = new Vector();
        v = DepartmentDAO.getComboBoxDepartment();
        cbDepartmentSelect.setModel(new DefaultComboBoxModel(v));
    }
    
    public void loadLocationSelect() throws SQLException{
        Vector v = new Vector();
        v = LocationDAO.getComboBoxLocationIDFromDBSelect();
        cbLocationSelect.setModel(new DefaultComboBoxModel(v));
    }
    
    public void loadProjectSelect() throws SQLException{
        Vector v = new Vector();
        v = ProjectDAO.getComboBoxProjectIDSelect();
        cbProjectSelect.setModel(new DefaultComboBoxModel(v));
    }
    
    public void loadEmployeeNameSelect() throws SQLException{
        Vector v = new Vector();
        v = EmployeeDAO.getComboboxEmployeeSelect();
        cbSearchEmployee.setModel(new DefaultComboBoxModel(v));
    }
    
    public void loadSearchLocation() throws SQLException{
        Vector v = new Vector();
        v = LocationDAO.getComboBoxLocationFromDB();
        cbSearchLocation.setModel(new DefaultComboBoxModel(v));
        cbEmployeeLocation.setModel(new DefaultComboBoxModel(v));
        cbSearchTransferByCurrentLocation.setModel(new DefaultComboBoxModel(v));
        cbSearchTransferByToLocation.setModel(new DefaultComboBoxModel(v));
        cbTransferToLocation.setModel(new DefaultComboBoxModel(v));
    }
    
    public void loadSearchDerpartment() throws SQLException{
        Vector v = new Vector();
        v = DepartmentDAO.getComboBoxDepartmentFromDB();
        cbSearchDepartment.setModel(new DefaultComboBoxModel(v));
        cbEmployeeDepartment.setModel(new DefaultComboBoxModel(v));
        cbSearchTransferByCurrentDepartment.setModel(new DefaultComboBoxModel(v));
        cbSearchTransferByToDepartment.setModel(new DefaultComboBoxModel(v));
        cbTransferToDepartment.setModel(new DefaultComboBoxModel(v));
    }
        
    public void loadSearchProject() throws SQLException{
        Vector v = new Vector();
        v = ProjectDAO.getComboBoxProjectFromDB();
        cbSearchProject.setModel(new DefaultComboBoxModel(v));
        cbEmployeeProject.setModel(new DefaultComboBoxModel(v));
        cbSearchTransferByCurrentProject.setModel(new DefaultComboBoxModel(v));
        cbSearchTransferByToProject.setModel(new DefaultComboBoxModel(v));
        cbTransferToProject.setModel(new DefaultComboBoxModel(v));
    }
    
    public void loadSearchEmployee() throws SQLException{
        Vector v = new Vector();
        v = EmployeeDAO.getComboboxEmployee();
        //cbSearchEmployee.setModel(new DefaultComboBoxModel(v));
        //cbDepartmentSelect.setModel(new DefaultComboBoxModel(v));
        cbSearchTransferByEmployeeName.setModel(new DefaultComboBoxModel(v));
    }
    
    public void searchProjectName(){
        objDBUtil = new DBUtil();
        conn = objDBUtil.connect();
        String searchProjectName = (String) cbSearchProject.getSelectedItem();
        try {
            // TODO add your handling code here:
            rsProject = objDBUtil.executeSQL("SELECT * FROM Project WHERE ProjectName='" + searchProjectName + "'");
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
    
    public void searchLocationName(){
        objDBUtil = new DBUtil();
        conn = objDBUtil.connect();
        String searchLocationName = (String) cbSearchLocation.getSelectedItem();
        try {
            // TODO add your handling code here:
            rsLocation = objDBUtil.executeSQL("SELECT * FROM Location WHERE LocationName='" + searchLocationName + "'");
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
    
   public void searchDepartmentName(){
        objDBUtil = new DBUtil();
        conn = objDBUtil.connect();
        String searchDepartmentName = (String) cbSearchDepartment.getSelectedItem();
        try {
            // TODO add your handling code here:
            rsDepartment = objDBUtil.executeSQL("SELECT * FROM Department WHERE DepartmentName='" + searchDepartmentName + "'");
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
   
   public void searchEmployeeName(){
       objDBUtil = new DBUtil();
       conn = objDBUtil.connect();
       String searchEmployeeName = (String) cbSearchEmployee.getSelectedItem();
        try {
            rsEmployee = objDBUtil.executeSQL("SELECT * FROM Employee WHERE EmployeeName='" + searchEmployeeName + "'");
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }   
   }
   
   public void searchTransferByEmployeeID(){
       objDBUtil = new DBUtil();
       conn = objDBUtil.connect();
       String employeeID = txtSearchTransferByEmployeeID.getText();
        try {
            rsTransfer = objDBUtil.executeSQL("SELECT * FROM TRANSFER WHERE EMPLOYEEID = '" + employeeID + "'");
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
   }
   
   public void searchTransferByEmployeeName(){
       objDBUtil = new DBUtil();
       conn = objDBUtil.connect();
       
        try {
            String employeeName = (String) cbSearchTransferByEmployeeName.getSelectedItem();
       String employeeID = EmployeeDAO.getEmployeeID(employeeName);
            rsTransfer = objDBUtil.executeSQL("SELECT * FROM TRANSFER WHERE EMPLOYEEID = '" + employeeID + "'");
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
   }
    
    public void searchTransferByCurrentLocation(){
        objDBUtil = new DBUtil();
        conn = objDBUtil.connect();
        try {
            String currentLocationName = (String) cbSearchTransferByCurrentLocation.getSelectedItem();
            String currentLocationID = LocationDAO.getLocationID(currentLocationName);
            rsTransfer = objDBUtil.executeSQL("SELECT * FROM TRANSFER WHERE FROMLOCATIONID = '" + currentLocationID + "'");
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
    
    public void searchTransferByCurrentDepartment(){
        objDBUtil = new DBUtil();
        conn = objDBUtil.connect();
        try {
            String currentdepartmentID = DepartmentDAO.getDepartmentID((String) cbSearchTransferByCurrentDepartment.getSelectedItem());
            rsTransfer = objDBUtil.executeSQL("SELECT * FROM TRANSFER WHERE FROMDEPARTMENTID = '" + currentdepartmentID + "'");
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
   
    public void searchTransferByCurrentProject(){
        objDBUtil = new DBUtil();
        conn = objDBUtil.connect();
        try {
            String currentProjectID = ProjectDAO.getProjectID((String) cbSearchTransferByCurrentProject.getSelectedItem());
            rsTransfer = objDBUtil.executeSQL("SELECT * FROM TRANSFER WHERE FROMPROJECTID = '" + currentProjectID + "'");
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
    
    public void searchTransferByToProject(){
        objDBUtil = new DBUtil();
        conn = objDBUtil.connect();
        try {
            String toProjectID = ProjectDAO.getProjectID((String) cbSearchTransferByToProject.getSelectedItem());
            rsTransfer = objDBUtil.executeSQL("SELECT * FROM TRANSFER WHERE TOPROJECTID = '" + toProjectID + "'");
            int count = 0;
            
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
    
    public void searchTransferByToLocation(){
        objDBUtil = new DBUtil();
        conn = objDBUtil.connect();
        try {
            String toLocationID = LocationDAO.getLocationID((String) cbSearchTransferByToLocation.getSelectedItem());
            rsTransfer = objDBUtil.executeSQL("SELECT * FROM TRANSFER WHERE TOLOCATIONID = '" + toLocationID + "'");
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
    
    public void searchTransferByToDepartment(){
        objDBUtil = new DBUtil();
        conn = objDBUtil.connect();
        try {
            String toDepartmentID = DepartmentDAO.getDepartmentID((String) cbSearchTransferByToDepartment.getSelectedItem());
            rsTransfer = objDBUtil.executeSQL("SELECT * FROM TRANSFER WHERE TODEPARTMENTID = '" + toDepartmentID + "'");
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
    
    public void searchEmployeeByProject(){
        objDBUtil = new DBUtil();
        conn = objDBUtil.connect();
        try {
            String projectID = ProjectDAO.getProjectID((String)cbProjectSelect.getSelectedItem());
            rsEmployee = objDBUtil.executeSQL("SELECT * FROM EMPLOYEE WHERE PROJECTID = '" + projectID + "'");
        } catch (SQLException ex) {
            //JOptionPane.showMessageDialog(null, "Do Not Find");
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
    
    public void searchEmployeeByLocation(){
        objDBUtil = new DBUtil();
        conn = objDBUtil.connect();
        try {
            String locationID = LocationDAO.getLocationID((String) cbLocationSelect.getSelectedItem());
            rsEmployee = objDBUtil.executeSQL("SELECT * FROM EMPLOYEE WHERE LOCATIONID = '" + locationID + "'");
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
    
    public void searchEmployeeByDepartment(){
        objDBUtil = new DBUtil();
        conn = objDBUtil.connect();
        try {
            String departmentID = DepartmentDAO.getDepartmentID((String) cbDepartmentSelect.getSelectedItem());
            rsEmployee = objDBUtil.executeSQL("SELECT * FROM EMPLOYEE WHERE DEPARTMENTID = '" + departmentID + "'");
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
    
    private void jTabbedPane2MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTabbedPane2MouseClicked
        // TODO add your handling code here:
    }//GEN-LAST:event_jTabbedPane2MouseClicked

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
        // TODO add your handling code here:
        ChangePass change = new ChangePass();
        change.setLocationRelativeTo(change);
        change.setVisible(true);  
    }//GEN-LAST:event_jButton1ActionPerformed

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed
        // TODO add your handling code here:
                // TODO add your handling code here:
    }//GEN-LAST:event_jButton3ActionPerformed

    private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton4ActionPerformed
        // TODO add your handling code here:
        int confirm = JOptionPane.showConfirmDialog(null, "LogOut", "Messager", JOptionPane.YES_NO_OPTION);
        if (confirm == JOptionPane.YES_OPTION) {
            Login lo = new Login(this, rootPaneCheckingEnabled);
            lo.setLocationRelativeTo(lo);
            this.dispose();
            lo.setVisible(true);
        }
    }//GEN-LAST:event_jButton4ActionPerformed

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
        // TODO add your handling code here:
        Version ver = new Version();
        ver.setLocationRelativeTo(ver);
        ver.setVisible(true);
    }//GEN-LAST:event_jButton2ActionPerformed

    private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton5ActionPerformed
        // TODO add your handling code here:
        int confirm = JOptionPane.showConfirmDialog(null,"Exit", "Messager", JOptionPane.YES_NO_OPTION);
        if (confirm == JOptionPane.YES_OPTION) {
            this.dispose();
        }
    }//GEN-LAST:event_jButton5ActionPerformed

    private void btnSearchProjectActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnSearchProjectActionPerformed
        String searchProjectID = txtSearchProjectID.getText();
        String searchProjectName = (String) cbSearchProject.getSelectedItem();
        if (!CheckInfo.checkEmpty(searchProjectID)) {
            if (cbSearchProject.getSelectedIndex() == 0) {
                JOptionPane.showMessageDialog(null, "Enter for Key Word");
            } else{
                try {
                    int countSearch = ProjectDAO.searchProjectByName((String) cbSearchProject.getSelectedItem());
                    if (countSearch == 1) {
                        String key = "Result: 1" + "  For Keyword Search:  " + searchProjectName;
                        jLabel10.setText(key);
                    }
                    else {
                        String key = "Result:  " + String.valueOf(countSearch) + "  For Keyword Search:  " + searchProjectName;
                        jLabel10.setText(key);
                    }
                } catch (SQLException ex) {
                    Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
                }
                searchProjectName();
                try {
                    rsProject.first();
                    lblProjectStt.setText(rsProject.getString(1));
                    lblProjectID.setText(rsProject.getString(2));
                    txtProjectName.setText(rsProject.getString(3));
                    txtProjectAllowance.setText(rsProject.getString(4));
                    
                    txtSearchProjectID.requestFocus();
                    cbSearchProject.setSelectedIndex(0);
                    lblProjectStt.setEnabled(true);
                    lblProjectID.setEnabled(true);
                    txtProjectName.setEnabled(true);
                    txtProjectAllowance.setEnabled(true);
                } catch (SQLException ex) {
                    Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
                }
                
            }
        } else{
            try {
                String stt = String.valueOf(ProjectDAO.searchProjectByID(searchProjectID).getStt());
                String projectID = ProjectDAO.searchProjectByID(searchProjectID).getProjectID();
                String projectName = ProjectDAO.searchProjectByID(searchProjectID).getProjectName();
                String projectAllowance = String.valueOf(ProjectDAO.searchProjectByID(searchProjectID).getProjectAllowance());
                int count = ProjectDAO.countSearchProjectByID(txtSearchProjectID.getText());
                String KeySearchProjectID = txtSearchProjectID.getText();
                
                lblProjectStt.setText(stt);
                lblProjectID.setText(projectID);
                txtProjectName.setText(projectName);
                txtProjectAllowance.setText(projectAllowance);
                
                txtSearchProjectID.setText("");
                txtSearchProjectID.requestFocus();
                lblProjectStt.setEnabled(true);
                lblProjectID.setEnabled(true);
                txtProjectName.setEnabled(true);
                txtProjectAllowance.setEnabled(true);
                String key = "Result:  " + String.valueOf(count) + "  For Keyword Search:  " + searchProjectID;
                jLabel10.setText(key);
            } catch (SQLException ex) {
                Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
    }//GEN-LAST:event_btnSearchProjectActionPerformed

    private void btnSearchLocationActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnSearchLocationActionPerformed
        // TODO add your handling code here:
        String searchLocationID = txtSearchLocation.getText();
        String searchLocationName = (String) cbSearchLocation.getSelectedItem();
        if (!CheckInfo.checkEmpty(searchLocationID)) {
            if (cbSearchLocation.getSelectedIndex() == 0) {
                JOptionPane.showMessageDialog(null, "Enter for Key Word");
            } else {
                try {
                    int countSearch = LocationDAO.searchLocationByName(searchLocationName);
                    if (countSearch == 1) {
                        String key = "Result: 1" + "  For Keyword Search:  " + searchLocationName;
                        jLabel11.setText(key);
                    } else {
                        String key = "Result:  " + String.valueOf(countSearch) + "  For Keyword Search:  " + searchLocationName;
                        jLabel11.setText(String.valueOf(key));
                    }
                } catch (SQLException ex) {
                    Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
                }
                try {
                    searchLocationName();
                    rsLocation.first();
                    txtLocationStt.setText(rsLocation.getString(1));
                    txtLocationID.setText(rsLocation.getString(2));
                    txtLocationName.setText(rsLocation.getString(3));
                    txtLocationAllowance.setText(rsLocation.getString(4));

                    txtSearchLocation.requestFocus();
                    cbSearchLocation.setSelectedIndex(0);
                    txtLocationStt.setEnabled(true);
                    txtLocationName.setEnabled(true);
                    txtLocationID.setEnabled(true);
                    txtLocationAllowance.setEnabled(true);
                } catch (SQLException ex) {
                    Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        } else {
                try {
                    String stt = String.valueOf(LocationDAO.searchLocationByID(searchLocationID).getStt());
                    String locationID = LocationDAO.searchLocationByID(searchLocationID).getLocationID();
                    String locationName = LocationDAO.searchLocationByID(searchLocationID).getLocationName();
                    String locationAllowance = String.valueOf(LocationDAO.searchLocationByID(searchLocationID).getLocationAllowance());
                    int countSearchLocationID = LocationDAO.countSearchLocationID(searchLocationID);
                    
                    txtLocationStt.setText(stt);
                    txtLocationID.setText(locationID);
                    txtLocationName.setText(locationName);
                    txtLocationAllowance.setText(locationAllowance);
                    
                    txtSearchLocation.setText("");
                    txtSearchLocation.requestFocus();
                    txtLocationStt.setEnabled(true);
                    txtLocationName.setEnabled(true);
                    txtLocationID.setEnabled(true);
                    txtLocationAllowance.setEnabled(true);
                    String key = "Result:  " + String.valueOf(countSearchLocationID) + "  For Keyword Search:  " + searchLocationID;
                    jLabel11.setText(key);
                } catch (SQLException ex) {
                    Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
                }
        }
    }//GEN-LAST:event_btnSearchLocationActionPerformed

    private void btnSearchDepartmentActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnSearchDepartmentActionPerformed
        // TODO add your handling code here:
        String searchDepartmentID = txtSearchDepartment.getText();
        String searchDepartmentName = (String) cbSearchDepartment.getSelectedItem();
        if (!CheckInfo.checkEmpty(searchDepartmentID)) {
            if (cbSearchDepartment.getSelectedIndex() == 0) {
                JOptionPane.showMessageDialog(null, "Enter for Key Word");
            } else {
                try {
                    int countSearch = DepartmentDAO.searchDepartmentByName(searchDepartmentName);
                    if (countSearch == 1) {
                        String key = "Result: 1" + "  For Keyword Search:  " + searchDepartmentName;
                        jLabel30.setText(key);
                    } else {
                        String key = "Result:  " + String.valueOf(countSearch) + "  For Keyword Search:  " + searchDepartmentName;
                        jLabel30.setText(key);                        
                    }
                } catch (SQLException ex) {
                    Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
                }
                try {
                    searchDepartmentName();
                    rsDepartment.first();
                    txtDepartmentStt.setText(rsDepartment.getString(1));
                    txtDepartmentID.setText(rsDepartment.getString(2));
                    txtDepartmentName.setText(rsDepartment.getString(3));
                    txtDepartmentAllowance.setText(rsDepartment.getString(4));
                    
                    txtDepartmentStt.setEnabled(true);
                    txtDepartmentID.setEnabled(true);
                    txtDepartmentName.setEnabled(true);
                    txtDepartmentAllowance.setEnabled(true);
                    cbSearchDepartment.setSelectedIndex(0);
                    txtSearchDepartment.requestFocus();
                } catch (SQLException ex) {
                    Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        } else {
                try {
                    String stt = String.valueOf(DepartmentDAO.searchDepartmentByID(searchDepartmentID).getStt());
                    String departmentID = DepartmentDAO.searchDepartmentByID(searchDepartmentID).getDepartmentID();
                    String departmentName = DepartmentDAO.searchDepartmentByID(searchDepartmentID).getDepartmentName();
                    String departmetnAllowance = String.valueOf(DepartmentDAO.searchDepartmentByID(searchDepartmentID).getDepartmentAllowance());
                    int countSearchDepartmentID = DepartmentDAO.countSearchDepartmentID(searchDepartmentID);
                    
                    txtDepartmentStt.setText(stt);
                    txtDepartmentID.setText(departmentID);
                    txtDepartmentName.setText(departmentName);
                    txtDepartmentAllowance.setText(departmetnAllowance);
                    
                    txtSearchDepartment.setText("");
                    txtSearchDepartment.requestFocus();
                    txtDepartmentStt.setEnabled(true);
                    txtDepartmentID.setEnabled(true);
                    txtDepartmentName.setEnabled(true);
                    txtDepartmentAllowance.setEnabled(true);
                    String key = "Result:  " + String.valueOf(countSearchDepartmentID) + "  For Keyword Search:  " + searchDepartmentID;
                    jLabel30.setText(key);
                } catch (SQLException ex) {
                    Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
                }
        }
    }//GEN-LAST:event_btnSearchDepartmentActionPerformed

    private void jMenuItem2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem2ActionPerformed
        // TODO add your handling code here:
        ChangePass add = new ChangePass();
        add.setLocationRelativeTo(add);
        add.setVisible(true);
    }//GEN-LAST:event_jMenuItem2ActionPerformed

    private void jMenuItem3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem3ActionPerformed
        // TODO add your handling code here:
        int confirm = JOptionPane.showConfirmDialog(null, "LogOut", "Messager", JOptionPane.YES_NO_OPTION);
        if (confirm == JOptionPane.YES_OPTION) {
            Login lo = new Login(this, rootPaneCheckingEnabled);
            lo.setLocationRelativeTo(lo);
            this.dispose();
            lo.setVisible(true);
        }
    }//GEN-LAST:event_jMenuItem3ActionPerformed

    private void jMenuItem4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem4ActionPerformed
        // TODO add your handling code here:
        int confirm = JOptionPane.showConfirmDialog(null,"Exit", "Messager", JOptionPane.YES_NO_OPTION);
        if (confirm == JOptionPane.YES_OPTION) {
            this.dispose();
        }
    }//GEN-LAST:event_jMenuItem4ActionPerformed

    private void btnViewDetaiTotalTransferApprovelActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnViewDetaiTotalTransferApprovelActionPerformed
        // TODO add your handling code here:
        TotalTransferApprove total = new TotalTransferApprove();
        total.setLocationRelativeTo(total);
        total.setVisible(true);
    }//GEN-LAST:event_btnViewDetaiTotalTransferApprovelActionPerformed

    private void btnViewDetailTotalTransferNotApproveActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnViewDetailTotalTransferNotApproveActionPerformed
        // TODO add your handling code here:
        TotalTransferNotApprove total = new TotalTransferNotApprove();
        total.setLocationRelativeTo(total);
        total.setVisible(true);
    }//GEN-LAST:event_btnViewDetailTotalTransferNotApproveActionPerformed

    private void btnViewDetailTotalTransferActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnViewDetailTotalTransferActionPerformed
        // TODO add your handling code here:
        TotalTransfer total = new TotalTransfer();
        total.setLocationRelativeTo(total);
        total.setVisible(true);
    }//GEN-LAST:event_btnViewDetailTotalTransferActionPerformed

    private void btnViewDetailTotalEmployeeActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnViewDetailTotalEmployeeActionPerformed
        // TODO add your handling code here:
        TotalEmployee total = new TotalEmployee();
        total.setLocationRelativeTo(total);
        total.setVisible(true);
    }//GEN-LAST:event_btnViewDetailTotalEmployeeActionPerformed

    private void btnViewDetailTotalProjectActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnViewDetailTotalProjectActionPerformed
        // TODO add your handling code here
        TotalProject total = new TotalProject();
        total.setLocationRelativeTo(total);
        total.setVisible(true);
    }//GEN-LAST:event_btnViewDetailTotalProjectActionPerformed

    private void btnViewDetailTotalLocationActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnViewDetailTotalLocationActionPerformed
        // TODO add your handling code here:
        TotalLocation total = new TotalLocation();
        total.setLocationRelativeTo(total);
        total.setVisible(true);
    }//GEN-LAST:event_btnViewDetailTotalLocationActionPerformed

    private void btnViewDetailTotalDepartmentActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnViewDetailTotalDepartmentActionPerformed
        // TODO add your handling code here:
        TotalDepartment total = new TotalDepartment();
        total.setLocationRelativeTo(total);
        total.setVisible(true);
    }//GEN-LAST:event_btnViewDetailTotalDepartmentActionPerformed

    private void cbDepartmentSelectActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cbDepartmentSelectActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_cbDepartmentSelectActionPerformed

    private void txtSearchEmployeeIDActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_txtSearchEmployeeIDActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_txtSearchEmployeeIDActionPerformed

    private void cbSearchDepartmentActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cbSearchDepartmentActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_cbSearchDepartmentActionPerformed

    private void btnSearchEmployeeActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnSearchEmployeeActionPerformed
        // TODO add your handling code here:
        String searchEmployeeID = txtSearchEmployeeID.getText();
        String searchEmployeeName = (String) cbSearchEmployee.getSelectedItem();
        String searchByProjectName = (String) cbProjectSelect.getSelectedItem();
        String searchByLocationName = (String) cbLocationSelect.getSelectedItem();
        String searchByDepartmentName = (String) cbDepartmentSelect.getSelectedItem();
                
        if (!CheckInfo.checkEmpty(searchEmployeeID)) {
            if (cbSearchEmployee.getSelectedIndex() == 0) {
                if (cbProjectSelect.getSelectedIndex() == 0) {
                    if (cbLocationSelect.getSelectedIndex() == 0) {
                        if (cbDepartmentSelect.getSelectedIndex() == 0) {
                            JOptionPane.showMessageDialog(null, "Enter for Key Word");
                        } else{
                            try {
                                int countSearch = EmployeeDAO.countSearchEmployeeByDepartment(DepartmentDAO.getDepartmentID(searchByDepartmentName));
                                if (countSearch == 1) {
                                    jButton25.setEnabled(false);
                                    jButton26.setEnabled(false);
                                    jButton27.setEnabled(false);
                                    jButton28.setEnabled(false);
                                    String key = "Result: 1 For Keyword Search:  " + searchByDepartmentName;
                                    jLabel41.setText(key);
                                } else{
                                    jButton25.setEnabled(true);
                                    jButton26.setEnabled(true);
                                    jButton27.setEnabled(true);
                                    jButton28.setEnabled(true);
                                    String key = "Result: " + countSearch + "  For Keyword Search:  " + searchByDepartmentName;
                                    jLabel41.setText(key);
                                }
                                searchEmployeeByDepartment();
                                index = 1;
                                abc = DepartmentDAO.getDepartmentID(searchByDepartmentName);
                                rsEmployee.first();
                                resultEmployee();
                                txtSearchEmployeeID.setText("");
                                cbSearchEmployee.setSelectedIndex(0);
                                cbProjectSelect.setSelectedIndex(0);
                                cbLocationSelect.setSelectedIndex(0);
                                cbDepartmentSelect.setSelectedIndex(0);
                            } catch (SQLException ex) {
                                resetSearchEmployee();
                                JOptionPane.showMessageDialog(null, "Do Not Find");
                            }
                        }
                    } else{
                        try {
                            int countSearch = EmployeeDAO.countSearchEmployeeByLocation(LocationDAO.getLocationID(searchByLocationName));
                            if (countSearch == 1) {
                                jButton25.setEnabled(false);
                                jButton26.setEnabled(false);
                                jButton27.setEnabled(false);
                                jButton28.setEnabled(false);
                                String key = "Result: 1 For Keyword Search:  " + searchByLocationName;
                                jLabel41.setText(key);
                            } else{
                                jButton25.setEnabled(true);
                                jButton26.setEnabled(true);
                                jButton27.setEnabled(true);
                                jButton28.setEnabled(true);
                                String key = "Result: " + countSearch + "  For Keyword Search:  " + searchByLocationName;
                                jLabel41.setText(key);
                            }
                            searchEmployeeByLocation();
                            index = 2;
                            abc = LocationDAO.getLocationID(searchByLocationName);
                            rsEmployee.first();
                            resultEmployee();
                            txtSearchEmployeeID.setText("");
                            cbSearchEmployee.setSelectedIndex(0);
                            cbProjectSelect.setSelectedIndex(0);
                            cbLocationSelect.setSelectedIndex(0);
                            cbDepartmentSelect.setSelectedIndex(0);
                        } catch (SQLException ex) {
                            resetSearchEmployee();
                            JOptionPane.showMessageDialog(null, "Do Not Find");
                        }
                    }
                } else{
                    try {
                        int countSearch = EmployeeDAO.countSearchEmployeeByProject(ProjectDAO.getProjectID(searchByProjectName));
                        if (countSearch == 1) {
                            jButton25.setEnabled(false);
                            jButton26.setEnabled(false);
                            jButton27.setEnabled(false);
                            jButton28.setEnabled(false);
                            String key = "Result: 1 For Keyword Search:  " + searchByProjectName;
                            jLabel41.setText(key);
                        } else{
                            jButton25.setEnabled(true);
                            jButton26.setEnabled(true);
                            jButton27.setEnabled(true);
                            jButton28.setEnabled(true);
                            String key = "Result: " + countSearch + "  For Keyword Search:  " + searchByProjectName;
                            jLabel41.setText(key);
                        }
                        searchEmployeeByProject();
                        index = 3;
                        abc = ProjectDAO.getProjectID(searchByProjectName);
                        rsEmployee.first();
                        resultEmployee();
                        txtSearchEmployeeID.setText("");
                        cbSearchEmployee.setSelectedIndex(0);
                        cbProjectSelect.setSelectedIndex(0);
                        cbLocationSelect.setSelectedIndex(0);
                        cbDepartmentSelect.setSelectedIndex(0);
                    } catch (SQLException ex) {
                        resetSearchEmployee();
                        JOptionPane.showMessageDialog(null, "Do Not Find");
                        //Logger.getLogger(AdminMain.class.getName()).log(Level.SEVERE, null, ex);
                    }
                }
                //
            } else{
                try {
                    int countSearch = EmployeeDAO.countSearchEmployeeByName(searchEmployeeName);
                    if (countSearch == 1) {
                        jButton25.setEnabled(false);
                        jButton26.setEnabled(false);
                        jButton27.setEnabled(false);
                        jButton28.setEnabled(false);
                        String key = "Result: 1 For Keyword Search:  " + searchEmployeeName;
                        jLabel41.setText(key);
                    } else{
                        jButton25.setEnabled(true);
                        jButton26.setEnabled(true);
                        jButton27.setEnabled(true);
                        jButton28.setEnabled(true);
                        String key = "Result: " + countSearch + "  For Keyword Search:  " + searchEmployeeName;
                        jLabel41.setText(key);
                    }
                    searchEmployeeName();
                    index = 4;
                    abc = searchEmployeeName;
                    rsEmployee.first();
                    resultEmployee();
                    txtSearchEmployeeID.setText("");
                    cbSearchEmployee.setSelectedIndex(0);
                    cbProjectSelect.setSelectedIndex(0);
                    cbLocationSelect.setSelectedIndex(0);
                    cbDepartmentSelect.setSelectedIndex(0);
                } catch (SQLException ex) {
                    Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        } else{
            try {
                txtSTTEmployee.setText(String.valueOf(EmployeeDAO.searchEmployeeByID(searchEmployeeID).getStt()));
                txtEmployeeID.setText(EmployeeDAO.searchEmployeeByID(searchEmployeeID).getEmployeeID());
                txtEmployeeName.setText(EmployeeDAO.searchEmployeeByID(searchEmployeeID).getEmployeeName());
                if (EmployeeDAO.searchEmployeeByID(searchEmployeeID).getGender() == true) {
                    jRadioButton1.setSelected(true);
                } else {
                    jRadioButton2.setSelected(true);
                }
                jDateDayOfBirth.setDate(EmployeeDAO.searchEmployeeByID(searchEmployeeID).getDayOfBirth());
//                txtDayOfBirth.setText(String.valueOf(EmployeeDAO.searchEmployeeByID(searchEmployeeID).getDayOfBirth()));
                txtAddress.setText(EmployeeDAO.searchEmployeeByID(searchEmployeeID).getAddress());
                txtPhoneNumber.setText(EmployeeDAO.searchEmployeeByID(searchEmployeeID).getPhone());
                txtEmail.setText(EmployeeDAO.searchEmployeeByID(searchEmployeeID).getEmail());
                txtWorkEx.setText(String.valueOf(EmployeeDAO.searchEmployeeByID(searchEmployeeID).getWorkExperience()));
                txtPassword.setText(EmployeeDAO.searchEmployeeByID(searchEmployeeID).getPassword());
                txtConfirmPassword.setText(EmployeeDAO.searchEmployeeByID(searchEmployeeID).getPassword());
                cbEmployeeLocation.setSelectedItem(EmployeeDAO.searchEmployeeByID(searchEmployeeID).getLocationID());
                cbEmployeeDepartment.setSelectedItem(EmployeeDAO.searchEmployeeByID(searchEmployeeID).getDepartmentID());
                cbEmployeeProject.setSelectedItem(EmployeeDAO.searchEmployeeByID(searchEmployeeID).getProjectID());
                
                txtSTTEmployee.setEnabled(true);
                txtEmployeeID.setEnabled(true);
                txtEmployeeName.setEnabled(true);
                jDateDayOfBirth.setEnabled(true);
                txtPhoneNumber.setEnabled(true);
                txtAddress.setEnabled(true);
                txtEmail.setEnabled(true);
                txtWorkEx.setEnabled(true);
                txtPassword.setEnabled(true);
                txtConfirmPassword.setEnabled(true);
                cbEmployeeLocation.setEnabled(true);
                cbEmployeeDepartment.setEnabled(true);
                cbEmployeeProject.setEnabled(true);
                jRadioButton1.setEnabled(true);
                jRadioButton2.setEnabled(true);
                jButton32.setEnabled(true);
                String key = "Result: 1 For Keyword Search:  " + searchEmployeeID;
                jLabel41.setText(key);
            } catch (SQLException ex) {
                Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
            }    
        }
    }//GEN-LAST:event_btnSearchEmployeeActionPerformed

    private void btnSearchTransferActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnSearchTransferActionPerformed
        // TODO add your handling code here:
        String searchByTransferID = txtSearchTransferID.getText();
        String searchByEmployeeID = txtSearchTransferByEmployeeID.getText();
        String searchByEmployeeName = (String) cbSearchTransferByEmployeeName.getSelectedItem();
        String searchByCurrentLocation = (String) cbSearchTransferByCurrentLocation.getSelectedItem();
        String searchByCurrentDepartment = (String) cbSearchTransferByCurrentDepartment.getSelectedItem();
        String searchByCurrentProject = (String) cbSearchTransferByCurrentProject.getSelectedItem();
        String searchByToLocation = (String) cbSearchTransferByToLocation.getSelectedItem();
        String searchByToDepartment = (String) cbSearchTransferByToDepartment.getSelectedItem();
        String searchByToProject = (String) cbSearchTransferByToProject.getSelectedItem();
        SearchTransferDetail transfer = new SearchTransferDetail();
        
        if (!CheckInfo.checkEmpty(searchByTransferID)) {
            if (!CheckInfo.checkEmpty(searchByEmployeeID)) {
                if (cbSearchTransferByEmployeeName.getSelectedIndex() == 0) {
                    if (cbSearchTransferByCurrentLocation.getSelectedIndex() == 0) {
                        if (cbSearchTransferByCurrentDepartment.getSelectedIndex() == 0) {
                            if (cbSearchTransferByCurrentProject.getSelectedIndex() == 0) {
                                if (cbSearchTransferByToLocation.getSelectedIndex() == 0) {
                                    if (cbSearchTransferByToDepartment.getSelectedIndex() == 0) {
                                        if (cbSearchTransferByToProject.getSelectedIndex() == 0) {
                                            JOptionPane.showMessageDialog(null, "You Are Need Enter For Key Word");
                                        } else{
                                            
                                            try {
                                                String projectName = (String) cbSearchTransferByToProject.getSelectedItem();
                                                String projectID = ProjectDAO.getProjectID(projectName);
                                                int count = TransferDAO.countSearchTransferByToProjectID(projectID);
                                                if (count > 0) {
                                                    String key = "Result:  " + count + "  For Key Word Search:  " + projectName;
                                                    jLabel66.setText(key);
                                                    index = 1;
                                                    abc = projectID;
                                                }
                                            } catch (SQLException ex) {
                                                Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
                                            }
                                            searchTransferByToProject();
                                            dontSee();
                                            
                                        } 
                                    } else {
                                        try {
                                            String departmentName = (String) cbSearchTransferByToDepartment.getSelectedItem();
                                            String departmentID = DepartmentDAO.getDepartmentID(departmentName);
                                            int count = TransferDAO.countSearchTransferByToDepartmentID(departmentID);
                                            if (count > 0) {
                                                String key = "Result:  " +  count + " For Key Word Search:  " + departmentName;
                                                jLabel66.setText(key);
                                                index = 2;
                                                abc = departmentID;
                                            }
                                        } catch (SQLException ex) {
                                            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
                                        }
                                        searchTransferByToDepartment();
                                        dontSee();
                                    }
                                } else{
                                    try {
                                        String locationName = (String) cbSearchTransferByToLocation.getSelectedItem();
                                        String locationID = LocationDAO.getLocationID(locationName);
                                        int count = TransferDAO.countSearchTransferByToLocationID(locationID);
                                        if (count > 0) {
                                            String key = "Result:  " + count + "  For Key Word Search:  " + locationName;
                                            jLabel66.setText(key);
                                            index = 3;
                                            abc = locationID;
                                        }
                                    } catch (SQLException ex) {
                                        Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
                                    }
                                    searchTransferByToLocation();
                                    dontSee();
                                }
                            } else{
                                try {
                                    String projectName = (String) cbSearchTransferByCurrentProject.getSelectedItem();
                                    String projectID = ProjectDAO.getProjectID(projectName);
                                    int count = TransferDAO.countSearchTransferByFromProjectID(projectID);
                                    if (count > 0) {
                                        String key = "Result:  " + count + "  For Key Word Search:  " + projectName;
                                        jLabel66.setText(key);
                                        index = 4;
                                        abc = projectID;
                                    }
                                } catch (SQLException ex) {
                                    Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
                                }
                                searchTransferByCurrentProject();
                                dontSee();
                            }
                        } else{
                            try {
                                String departmentName = (String) cbSearchTransferByCurrentDepartment.getSelectedItem();
                                String departmentID = DepartmentDAO.getDepartmentID(departmentName);
                                int count = TransferDAO.countSearchTransferByFromDepartmentID(departmentID);
                                if (count > 0) {
                                    String key = "Result:  " + count + "  For Key Word Search:  " + departmentName;
                                    jLabel66.setText(key);
                                    index = 5;
                                    abc = departmentID;
                                }
                            } catch (SQLException ex) {
                                Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
                            }
                            searchTransferByCurrentDepartment();
                            dontSee();
                        }
                    } else{
                        try {
                            String locationName = (String) cbSearchTransferByCurrentLocation.getSelectedItem();
                            String locationID = LocationDAO.getLocationID((String) cbSearchTransferByCurrentLocation.getSelectedItem());
                            int count = TransferDAO.countSearchTransferByFromLocationID(locationID);
                            if (count > 0) {
                                String key = "Result:  " + count + "  For Key Word Search:  " + locationName;
                                jLabel66.setText(key);
                                index = 6;
                                abc = locationID;
                            }
                        } catch (SQLException ex) {
                            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
                        }
                        searchTransferByCurrentLocation();
                        dontSee();
                    }
                } else{
                    try {
                        String employeeName = (String) cbSearchTransferByEmployeeName.getSelectedItem();
                        String employeeID = EmployeeDAO.getEmployeeID(employeeName);
                        int count = TransferDAO.countSearchTransferByEmployeeID(employeeID);
                        if (count > 0) {
                            String key = "Result:  " + count + "  For Key Word Search:  " + employeeName;
                            jLabel66.setText(key);
                            index = 7;
                            abc = employeeID;
                        }
                    } catch (SQLException ex) {
                        Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
                    }
                    searchTransferByEmployeeName();
                    dontSee();
                }
            } else{
                String employeeID = txtSearchTransferByEmployeeID.getText();
                try {
                    int count = TransferDAO.countSearchTransferByEmployeeID(employeeID);
                    if (count > 0) {
                        String key = "Result:  " + count + "  For Key Word Search:  " + employeeID;
                        jLabel66.setText(key);
                        index = 7;
                        abc = employeeID;
                    }
                } catch (SQLException ex) {
                    Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
                }
                searchTransferByEmployeeID();
                dontSee();
            }
        } else{
            try {
                String transferID = TransferDAO.searchTransferByID(searchByTransferID).getTransferID();
                String employeeID = TransferDAO.searchTransferByID(searchByTransferID).getEmployeeID();
                String currentLocation = LocationDAO.getLocationName(TransferDAO.searchTransferByID(searchByTransferID).getFromLocationID());
                String currentDepartment = DepartmentDAO.getDepartmentName(TransferDAO.searchTransferByID(searchByTransferID).getFromDepartmentID());
                String currentProject = ProjectDAO.getProjectName(TransferDAO.searchTransferByID(searchByTransferID).getFromProjectID());
                String toLocation = LocationDAO.getLocationName(TransferDAO.searchTransferByID(searchByTransferID).getToLocationID());
                String toDepartment = DepartmentDAO.getDepartmentName(TransferDAO.searchTransferByID(searchByTransferID).getToDepartmentID());
                String toProject = ProjectDAO.getProjectName(TransferDAO.searchTransferByID(searchByTransferID).getToProjectID());
                Boolean status = TransferDAO.searchTransferByID(searchByTransferID).getStatus();
                
                txtTransferID.setText(transferID);
                txtEmployeeIDFromTransfer.setText(employeeID);
                lblCurrentLocation.setText(currentLocation);
                lblCurrentDepartment.setText(currentDepartment);
                lblCurrentProject.setText(currentProject);
                cbTransferToLocation.setSelectedItem(toLocation);
                cbTransferToDepartment.setSelectedItem(toDepartment);
                cbTransferToProject.setSelectedItem(toProject);
                jDateJoinDate.setDate(TransferDAO.searchTransferByID(searchByTransferID).getJoinDate());
                jDateEndDate.setDate(TransferDAO.searchTransferByID(searchByTransferID).getEndDate());
                ckStatus.setSelected(status);
                String key = "Result: 1 For Search Key Word: " + searchByTransferID;
                jLabel66.setText(key);
                index = 8;
                abc = txtTransferID.getText();
                
                ckStatus.setEnabled(true);
                jDateEndDate.setEnabled(true);
                jDateJoinDate.setEnabled(true);
                cbTransferToLocation.setEnabled(true);
                cbTransferToDepartment.setEnabled(true);
                cbTransferToProject.setEnabled(true);
                txtTransferID.setEnabled(true);
                txtEmployeeIDFromTransfer.setEnabled(true);
                btnViewSearchTranfer.setEnabled(true);
                //cbCurrentLocationTransfer.setEnabled(true);
                //cbCurrentLocationTransfer.setSelectedItem(rsProject);
                txtSearchTransferID.setText("");
            } catch (SQLException ex) {
                Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
    }//GEN-LAST:event_btnSearchTransferActionPerformed

    private void jButton14ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton14ActionPerformed
        // TODO add your handling code here:
        try {
            // TODO add your handling code here:
            rsTransfer.first();
            jButton14.setEnabled(false);
            jButton15.setEnabled(false);
            jButton16.setEnabled(true);
            jButton17.setEnabled(true);
            travelTransfer();
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_jButton14ActionPerformed

    private void jButton15ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton15ActionPerformed
        // TODO add your handling code here:
        try {
            // TODO add your handling code here:
            if (rsTransfer.isFirst()) {
                jButton14.setEnabled(false);
                jButton15.setEnabled(false);
            } else {
                rsTransfer.previous();
                jButton16.setEnabled(true);
                jButton17.setEnabled(true);
                travelTransfer();
            }
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_jButton15ActionPerformed

    private void jButton16ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton16ActionPerformed
        // TODO add your handling code here:
        try {
            // TODO add your handling code here:
            if (rsTransfer.isLast()) {
                jButton16.setEnabled(false);
                jButton17.setEnabled(false);
            } else {
                rsTransfer.next();
                jButton14.setEnabled(true);
                jButton15.setEnabled(true);
                travelTransfer();
            }
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_jButton16ActionPerformed

    private void jButton17ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton17ActionPerformed
        // TODO add your handling code here:
        try {
            // TODO add your handling code here:
            rsTransfer.last();
            jButton14.setEnabled(true);
            jButton15.setEnabled(true);
            jButton16.setEnabled(false);
            jButton17.setEnabled(false);
            travelTransfer();
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_jButton17ActionPerformed

    private void txtSearchTransferIDMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtSearchTransferIDMouseClicked
        // TODO add your handling code here:
    }//GEN-LAST:event_txtSearchTransferIDMouseClicked

    private void btnViewSearchTranferActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnViewSearchTranferActionPerformed
        // TODO add your handling code here:
        SearchTransferDetail search = new SearchTransferDetail();
        search.setLocationRelativeTo(search);
        search.setVisible(true);
        search.LoadData(index, abc);
    }//GEN-LAST:event_btnViewSearchTranferActionPerformed

    private void cbProjectSelectActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cbProjectSelectActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_cbProjectSelectActionPerformed

    private void jButton25ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton25ActionPerformed
        try {
            // TODO add your handling code here:
            rsEmployee.first();
            jButton25.setEnabled(false);
            jButton26.setEnabled(false);
            jButton27.setEnabled(true);
            jButton28.setEnabled(true);
            resultEmployee();
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
            
    }//GEN-LAST:event_jButton25ActionPerformed

    private void jButton26ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton26ActionPerformed
        try {
            if (rsEmployee.isFirst()) {
                jButton25.setEnabled(false);
                jButton26.setEnabled(false);
            } else {
                rsEmployee.previous();
                jButton27.setEnabled(true);
                jButton28.setEnabled(true);
                resultEmployee();
            }
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_jButton26ActionPerformed

    private void jButton27ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton27ActionPerformed
        try {
            // TODO add your handling code here:
            if (rsEmployee.isLast()) {
                    jButton27.setEnabled(false);
                    jButton28.setEnabled(false);
                } else {
                    rsEmployee.next();
                    jButton25.setEnabled(true);
                    jButton26.setEnabled(true);
                    resultEmployee();
            }
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_jButton27ActionPerformed

    private void jButton28ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton28ActionPerformed
        try {
            // TODO add your handling code here:
            rsEmployee.last();
            jButton25.setEnabled(true);
            jButton26.setEnabled(true);
            jButton27.setEnabled(false);
            jButton28.setEnabled(false);
            resultEmployee();
        } catch (SQLException ex) {
            Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
        }
            
    }//GEN-LAST:event_jButton28ActionPerformed

    private void jButton32ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton32ActionPerformed
        // TODO add your handling code here:
        SearchEmployeeDetail a = new SearchEmployeeDetail();
        a.setLocationRelativeTo(a);
        a.setVisible(true);
        a.LoadData(index, abc);
    }//GEN-LAST:event_jButton32ActionPerformed

    private void jMenuItem5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem5ActionPerformed
        // TODO add your handling code here:
        try {
            // TODO add your handling code here:
            loadSearchDerpartment();
            loadSearchLocation();
            loadSearchProject();
            loadSearchEmployee();
            loadStatistical();
            loadDepartmentSelect();
            loadLocationSelect();
            loadProjectSelect();
            loadEmployeeNameSelect();
        } catch (SQLException ex) {
            Logger.getLogger(AdminMain.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_jMenuItem5ActionPerformed

    private void jMenuItem6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem6ActionPerformed
        // TODO add your handling code here:
        Version add = new Version();
        add.setLocationRelativeTo(add);
        add.setVisible(true);
    }//GEN-LAST:event_jMenuItem6ActionPerformed

    private void jMenuItem7ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem7ActionPerformed
        // TODO add your handling code here:
        TotalProject add = new TotalProject();
        add.setLocationRelativeTo(add);
        add.setVisible(true);
    }//GEN-LAST:event_jMenuItem7ActionPerformed

    private void jMenuItem10ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem10ActionPerformed
        // TODO add your handling code here:
        TotalEmployee add = new TotalEmployee();
        add.setLocationRelativeTo(add);
        add.setVisible(true);
    }//GEN-LAST:event_jMenuItem10ActionPerformed

    private void jMenuItem9ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem9ActionPerformed
        // TODO add your handling code here:
        TotalDepartment add = new TotalDepartment();
        add.setLocationRelativeTo(add);
        add.setVisible(true);
    }//GEN-LAST:event_jMenuItem9ActionPerformed

    private void jMenuItem8ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem8ActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_jMenuItem8ActionPerformed
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        /* Set the Nimbus look and feel */
        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
        /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
         * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
         */
        try {
            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
                if ("Nimbus".equals(info.getName())) {
                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
                    break;
                }
            }
        } catch (ClassNotFoundException ex) {
            java.util.logging.Logger.getLogger(EmployeeMain.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(EmployeeMain.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(EmployeeMain.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(EmployeeMain.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        //</editor-fold>

        /* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                try {
                    new EmployeeMain().setVisible(true);
                } catch (Exception ex) {
                    Logger.getLogger(EmployeeMain.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        });
    }
    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JButton btnSearchDepartment;
    private javax.swing.JButton btnSearchEmployee;
    private javax.swing.JButton btnSearchLocation;
    private javax.swing.JButton btnSearchProject;
    private javax.swing.JButton btnSearchTransfer;
    private javax.swing.JButton btnViewDetaiTotalTransferApprovel;
    private javax.swing.JButton btnViewDetailTotalDepartment;
    private javax.swing.JButton btnViewDetailTotalEmployee;
    private javax.swing.JButton btnViewDetailTotalLocation;
    private javax.swing.JButton btnViewDetailTotalProject;
    private javax.swing.JButton btnViewDetailTotalTransfer;
    private javax.swing.JButton btnViewDetailTotalTransferNotApprove;
    private javax.swing.JButton btnViewSearchTranfer;
    private javax.swing.ButtonGroup buttonGroup1;
    private javax.swing.JComboBox cbDepartmentSelect;
    private javax.swing.JComboBox cbEmployeeDepartment;
    private javax.swing.JComboBox cbEmployeeLocation;
    private javax.swing.JComboBox cbEmployeeProject;
    private javax.swing.JComboBox cbLocationSelect;
    private javax.swing.JComboBox cbProjectSelect;
    private javax.swing.JComboBox cbSearchDepartment;
    private javax.swing.JComboBox cbSearchEmployee;
    private javax.swing.JComboBox cbSearchLocation;
    private javax.swing.JComboBox cbSearchProject;
    private javax.swing.JComboBox cbSearchTransferByCurrentDepartment;
    private javax.swing.JComboBox cbSearchTransferByCurrentLocation;
    private javax.swing.JComboBox cbSearchTransferByCurrentProject;
    private javax.swing.JComboBox cbSearchTransferByEmployeeName;
    private javax.swing.JComboBox cbSearchTransferByToDepartment;
    private javax.swing.JComboBox cbSearchTransferByToLocation;
    private javax.swing.JComboBox cbSearchTransferByToProject;
    private javax.swing.JComboBox cbTransferToDepartment;
    private javax.swing.JComboBox cbTransferToLocation;
    private javax.swing.JComboBox cbTransferToProject;
    private javax.swing.JCheckBox ckStatus;
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton14;
    private javax.swing.JButton jButton15;
    private javax.swing.JButton jButton16;
    private javax.swing.JButton jButton17;
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton25;
    private javax.swing.JButton jButton26;
    private javax.swing.JButton jButton27;
    private javax.swing.JButton jButton28;
    private javax.swing.JButton jButton3;
    private javax.swing.JButton jButton32;
    private javax.swing.JButton jButton4;
    private javax.swing.JButton jButton5;
    private com.toedter.calendar.JDateChooser jDateDayOfBirth;
    private com.toedter.calendar.JDateChooser jDateEndDate;
    private com.toedter.calendar.JDateChooser jDateJoinDate;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel15;
    private javax.swing.JLabel jLabel16;
    private javax.swing.JLabel jLabel17;
    private javax.swing.JLabel jLabel18;
    private javax.swing.JLabel jLabel19;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel20;
    private javax.swing.JLabel jLabel21;
    private javax.swing.JLabel jLabel22;
    private javax.swing.JLabel jLabel23;
    private javax.swing.JLabel jLabel24;
    private javax.swing.JLabel jLabel25;
    private javax.swing.JLabel jLabel26;
    private javax.swing.JLabel jLabel27;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel30;
    private javax.swing.JLabel jLabel31;
    private javax.swing.JLabel jLabel32;
    private javax.swing.JLabel jLabel33;
    private javax.swing.JLabel jLabel34;
    private javax.swing.JLabel jLabel35;
    private javax.swing.JLabel jLabel36;
    private javax.swing.JLabel jLabel37;
    private javax.swing.JLabel jLabel38;
    private javax.swing.JLabel jLabel39;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel40;
    private javax.swing.JLabel jLabel41;
    private javax.swing.JLabel jLabel42;
    private javax.swing.JLabel jLabel43;
    private javax.swing.JLabel jLabel44;
    private javax.swing.JLabel jLabel45;
    private javax.swing.JLabel jLabel46;
    private javax.swing.JLabel jLabel47;
    private javax.swing.JLabel jLabel48;
    private javax.swing.JLabel jLabel49;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel50;
    private javax.swing.JLabel jLabel51;
    private javax.swing.JLabel jLabel52;
    private javax.swing.JLabel jLabel53;
    private javax.swing.JLabel jLabel54;
    private javax.swing.JLabel jLabel55;
    private javax.swing.JLabel jLabel56;
    private javax.swing.JLabel jLabel57;
    private javax.swing.JLabel jLabel58;
    private javax.swing.JLabel jLabel59;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel60;
    private javax.swing.JLabel jLabel61;
    private javax.swing.JLabel jLabel62;
    private javax.swing.JLabel jLabel63;
    private javax.swing.JLabel jLabel64;
    private javax.swing.JLabel jLabel65;
    private javax.swing.JLabel jLabel66;
    private javax.swing.JLabel jLabel67;
    private javax.swing.JLabel jLabel68;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JMenu jMenu1;
    private javax.swing.JMenu jMenu2;
    private javax.swing.JMenu jMenu3;
    private javax.swing.JMenu jMenu4;
    private javax.swing.JMenu jMenu5;
    private javax.swing.JMenuBar jMenuBar1;
    private javax.swing.JMenuItem jMenuItem10;
    private javax.swing.JMenuItem jMenuItem11;
    private javax.swing.JMenuItem jMenuItem2;
    private javax.swing.JMenuItem jMenuItem3;
    private javax.swing.JMenuItem jMenuItem4;
    private javax.swing.JMenuItem jMenuItem5;
    private javax.swing.JMenuItem jMenuItem6;
    private javax.swing.JMenuItem jMenuItem7;
    private javax.swing.JMenuItem jMenuItem8;
    private javax.swing.JMenuItem jMenuItem9;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel10;
    private javax.swing.JPanel jPanel11;
    private javax.swing.JPanel jPanel12;
    private javax.swing.JPanel jPanel13;
    private javax.swing.JPanel jPanel14;
    private javax.swing.JPanel jPanel15;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel3;
    private javax.swing.JPanel jPanel4;
    private javax.swing.JPanel jPanel5;
    private javax.swing.JPanel jPanel6;
    private javax.swing.JPanel jPanel7;
    private javax.swing.JPanel jPanel8;
    private javax.swing.JPanel jPanelDepartment;
    private javax.swing.JPanel jPanelEmployee;
    private javax.swing.JPanel jPanelHome;
    private javax.swing.JPanel jPanelLocation;
    private javax.swing.JPanel jPanelProject;
    private javax.swing.JPanel jPanelTransfer;
    private javax.swing.JRadioButton jRadioButton1;
    private javax.swing.JRadioButton jRadioButton2;
    private javax.swing.JToolBar.Separator jSeparator1;
    private javax.swing.JToolBar.Separator jSeparator2;
    private javax.swing.JToolBar.Separator jSeparator3;
    private javax.swing.JToolBar.Separator jSeparator4;
    private javax.swing.JTabbedPane jTabbedPane2;
    private javax.swing.JToolBar jToolBar1;
    private javax.swing.JToolBar jToolBar2;
    private javax.swing.JLabel lbkDateText;
    private javax.swing.JLabel lblCurrentDepartment;
    private javax.swing.JLabel lblCurrentLocation;
    private javax.swing.JLabel lblCurrentProject;
    private javax.swing.JLabel lblEmail;
    private javax.swing.JLabel lblEmailText;
    private javax.swing.JLabel lblFullName;
    private javax.swing.JLabel lblFullNameText;
    private javax.swing.JLabel lblProjectID;
    private javax.swing.JLabel lblProjectName;
    private javax.swing.JLabel lblProjectStt;
    private javax.swing.JLabel lblTotalApprove;
    private javax.swing.JLabel lblTotalDepartment;
    private javax.swing.JLabel lblTotalEmployee;
    private javax.swing.JLabel lblTotalLocation;
    private javax.swing.JLabel lblTotalNotApprove;
    private javax.swing.JLabel lblTotalProject;
    private javax.swing.JLabel lblTotalTransfer;
    private javax.swing.JTextField txtAddress;
    private javax.swing.JTextField txtConfirmPassword;
    private javax.swing.JTextField txtDepartmentAllowance;
    private javax.swing.JLabel txtDepartmentID;
    private javax.swing.JTextField txtDepartmentName;
    private javax.swing.JLabel txtDepartmentStt;
    private javax.swing.JTextField txtEmail;
    private javax.swing.JTextField txtEmployeeID;
    private javax.swing.JTextField txtEmployeeIDFromTransfer;
    private javax.swing.JTextField txtEmployeeName;
    private javax.swing.JTextField txtLocationAllowance;
    private javax.swing.JLabel txtLocationID;
    private javax.swing.JTextField txtLocationName;
    private javax.swing.JLabel txtLocationStt;
    private javax.swing.JTextField txtPassword;
    private javax.swing.JTextField txtPhoneNumber;
    private javax.swing.JTextField txtProjectAllowance;
    private javax.swing.JTextField txtProjectName;
    private javax.swing.JTextField txtSTTEmployee;
    private javax.swing.JTextField txtSearchDepartment;
    private javax.swing.JTextField txtSearchEmployeeID;
    private javax.swing.JTextField txtSearchLocation;
    private javax.swing.JTextField txtSearchProjectID;
    private javax.swing.JTextField txtSearchTransferByEmployeeID;
    private javax.swing.JTextField txtSearchTransferID;
    private javax.swing.JTextField txtTransferID;
    private javax.swing.JTextField txtWorkEx;
    // End of variables declaration//GEN-END:variables

}
